Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

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

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

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


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

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


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

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.