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

-
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 

1 reply

Best answer
approved by Jean-François Pillou on Nov 29, 2018
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
923
121
Thank you
You should write something like this :

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

Say "Thank you" 121

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 4565 users have said thank you to us this month

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