MrExcel Publishing
Your One Stop for Excel Tips & Solutions

current date & time entered automatically in cells in adjacent cells is entered


Posted by Jeff E on June 12, 2001 10:31 AM

I need to have the current date & time entered automatically in columns A & B, only as data is entered in column C. Is this possible?
Thanks


Posted by Jerid on June 12, 2001 11:28 AM

Hi Jeff

Try this =IF(C1<>"",NOW(),"")
You just need to format columns A & B as Date or Time.

Jerid

Posted by Matt Stone on June 12, 2001 11:38 AM

Try these:
Column a: =IF(C1<>"",NOW(),"")
Column b: =IF(C1<>"",NOW(),"")

Format cells in col a to be Date
Format Cells in col b to be time
(both in your preferred format)
Although these may update each time you open the
sheet... If you need one that stays the same
afterwords it's doable, but more complex...

Good luck,
Matt

Posted by Jeff E on June 13, 2001 10:55 AM

Thanks guys,
I should have also added that I need the date & time to be saved when a value in entered in cell c and not update everytime additional cells in c are filled in.
thanks