Date result in excel
Closed
Janelle
-
Nov 9, 2014 at 08:34 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 9, 2014 at 09:51 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 9, 2014 at 09:51 PM
Related:
- School result software in excel free download
- Fc 24 free download - Download - Sports
- Minecraft bedrock free download pc - Download - Sandbox
- Five nights in anime download - Download - Adult games
- Gta 5 download apk pc - Download - Action and adventure
- Save as pdf software - Download - Other
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Nov 9, 2014 at 09:51 PM
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.
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.