Thread: Finding the difference of two dates based on criterion.
View Single Post
 
Old 04-27-2010, 12:12 AM
aligahk06 aligahk06 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Aug 2009
Posts: 58
aligahk06 is on a distinguished road
Default Finding the difference of two dates based on criterion.
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
Reply With Quote