Date result in excel

Closed
Janelle - Nov 9, 2014 at 08:34 PM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - Nov 9, 2014 at 09:51 PM
Hello,
I am trying to solved this formula, I want to have a result in a cell Date now.
This is the issue, =if(I9="Done", Now())
Kindly correct please :) Thanks in advance.
Related:

1 response

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Nov 9, 2014 at 09:51 PM
Hello Janelle,

Your formula seems correct but you will need to format your selected display cell to Date or Time (or Custom for both Date and Time).

You may want to add ,"" after Now() so that your selected cell shows blank when there is no value in I9. So the amended formula should be:-

=IF(I9="Done",Now(),"").

I hope this helps.

Cheers,
vcoolio.