Date result in excel [Closed]

Report
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
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.

1 reply

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!