Setting a date and time based on other cell contents

Cathy C

New member
Joined
Jul 2, 2013
Messages
1
Reaction score
0
Points
0
Hi,
There is probably a simple solution to this, but I can't get it to work. I am setting up a workbook where Column A is set to the current date/time, based on Column B being populated. Column A should contain the word 'Blank' until a value is added. Using the following formula provides the date and time, but updates every line 'when the spreadsheet is opened, or a new row added.
=IF(ISBLANK(B59),"blank",NOW())

Is there a simple way to set Column A to the date/time of when Column B is populated, and not have it overridden??
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

=IF(B59="","blank",NOW())

or

=IF(ISNUMBER(B59),NOW(),"blank")

Note: If you only need date, then use TODAY() instead of NOW()... the latter gives date and time.
 
Top