#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Analysis of Amount based on following criterion. | aligahk06 | Excel | 1 | 04-24-2010 10:34 AM |
Finding a text style in a cell | jimbassett | Excel | 1 | 02-10-2010 08:39 PM |
finding contacts quickly | Jackdeanperry | Outlook | 0 | 12-21-2009 11:28 AM |
Finding the complements between the two data sets | psenku | Excel | 2 | 08-17-2009 11:15 PM |
Adding dates | mkkram | Word | 0 | 11-27-2006 09:18 AM |