Report

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

Ask a question Mike in PA - Last answered on Mar 17, 2017 at 01:20 PM by MEME
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 
Helpful
+121
plus moins
something like this

=IF(E22=DATE(2009,11,2),"done",D22-H22)
MEME- Mar 17, 2017 at 01:20 PM
Thank you. It saved my job.
Reply
Helpful
+30
plus moins
wow, great formula.
thanks

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!