Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-27-2010, 12:12 AM
aligahk06 aligahk06 is offline Finding the  difference of two dates based on criterion. Windows XP Finding the  difference of two dates based on criterion. Office 2007
Advanced Beginner
Finding the  difference of two dates based on criterion.
 
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
Reply

Thread Tools
Display Modes


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  difference of two dates based on criterion. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft