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

Mike in PA - Nov 22, 2009 at 11:00 AM - Latest reply:  salim
- Apr 29, 2018 at 08:16 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 

6 replies

Best answer
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Nov 22, 2009 at 10:11 PM
119
Thank you
something like this

=IF(E22=DATE(2009,11,2),"done",D22-H22)

Thank you, venkat1926 119

Something to say? Add comment

CCM has helped 1958 users this month

Thank you. It saved my job.
Thank you very much it saved lot of time
Thanks, U really help me out.
31
Thank you
wow, great formula.
thanks