Dear All,

Greetings of the day!!!!!!!!

I have two column say ColD and ColF.If ColD date is greater than & equla to 01/03/2010 and less than equal to 31/03/2010 ( First March 2010 and 31st march 2010)
and Col V contains the text "DISMANTLE" then subtract (ColF-ColD) (i.e difference of two date-19) and
If ColV contains the text other than "DISMANTLE" i.e ( Not Dismatle ) then difference of two dates i.e (ColF-01/03/2010).

Any help.

Rgds,

Aligahk06