Excel "IF" function w/ date in test cell

Solved/Closed

Mike in PA - Updated on May 28, 2018 at 09:12 AM
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)

If cell contains date then return value
Excel if cell contains date then return value - Best answers
If cell contains a date then return value - Best answers
If cell = date return yes or no. ✓ - Office Software Forum
If a cell has text then return value ✓ - Excel Forum
Excel: If Date =, then enter a value ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Updated on Nov 29, 2018 at 05:16 PM

You should write something like this :

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

Japs
Feb 24, 2013 at 08:18 PM

wow, great formula.
thanks

MEME
Mar 17, 2017 at 01:20 PM

Thank you. It saved my job.

Rc
Updated on Nov 24, 2017 at 04:39 AM

Thank you very much it saved lot of time

Areyqyu
Updated on Dec 27, 2017 at 02:13 AM

Thanks, U really help me out.

salim
Apr 29, 2018 at 08:16 AM

thanks help me too

Similar discussions

Find word within cell & put value in adjacent

Copy data onto sheet only if cell has text

If a cell contains any text then add a value

If cell = date return yes or no.

Excel - IF function with multiple words

Conditional formatting: change fontcolor based on another cell

Similar discussions

Subscribe To Our Newsletter!