Excel "IF" function w/ DATE in test cell [Solved/Closed]

Mike in PA - Nov 22, 2009 at 11:00 AM - Latest reply:  Areyqyu
- Dec 27, 2017 at 02:12 AM
Hello,

I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho, if it doesn't then I want it to calculate the difference between two cells that are populated with dates. The formula that I have been trying to get to work is shown below...any thoughts are greatly appreciated!

=IF(E22="mmddyyyy","Done",D22-H22)
See more 

5 replies

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus March 10, 2016 Last seen - Nov 22, 2009 at 10:11 PM
+118
Helpful
3
something like this

=IF(E22=DATE(2009,11,2),"done",D22-H22)
Was this answer helpful?  
Thank you. It saved my job.
Thank you very much it saved lot of time
Thanks, U really help me out.
+31
Helpful
wow, great formula.
thanks