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

Report
-
 salim -
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)

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
789
You should write something like this :

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

A few words of thanks would be greatly appreciated. Add comment

CCM 5567 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.
thanks help me too