HOW DO I Auto inserting date and time?

[Shane]

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]

thank you very much! that works perfectly!!

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

-Dave

 

[Dave Smith]

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

-Dave