Previous Topic Next Topic

Date result in excel

Closed
Janelle - Nov 9, 2014 at 08:34 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - 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

Answer 1 / 1
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
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.
0