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

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!

plus moins
something like this

Was this answer helpful?  
MEME- Mar 17, 2017 at 01:20 PM
Thank you. It saved my job.
plus moins
wow, great formula.

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!