Automatic fill a static date?

L

Lucky

Hi

I have a worksheet for handling incoming/outgoing packages.

Tired of putting in dates, when its always "today" im typing them in.

so i want a formula which will put in the date in a column whenever
type a name in another column.

this works, but whenever i open the document next day the day change
;)
=IF(B1<>"";TODAY();""
 
M

Myrna Larson

To totally eliminate keyboard entry, you need an event macro. If you try that
and don't like the speed "hit", you can press CTRL+; to enter the current date
in a cell. That will, of course, require you to tab over to the other column.
 
Top