HOW DO I Auto inserting date and time?

Shane · Sep 10, 2003

Can someone out there please help me!

Am trying to find what the formula would be to automatically insert date and
time (in seperate columns) when another field has been filled.

Ie, if cell C3 has data in it, then for C1 to automatically insert the date,
and C2 to automatically insert a time.

I am told that this IS possible, but I can't work out how to do it!

Thank you in advance for any assistance!

Shane

Shane · Sep 10, 2003

thank you very much! that works perfectly!!

Dave Smith said:
=IF(ISBLANK(C3),"",TODAY())
=IF(ISBLANK(C3),"",NOW())

-Dave

Dave Smith · Sep 10, 2003

=IF(ISBLANK(C3),"",TODAY())
=IF(ISBLANK(C3),"",NOW())

-Dave