Automatic fill a static date?

  • Thread starter Thread starter Lucky
  • Start date Start 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();""
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Colour code dates 1
fill in date into adjacent cell automatically 2
Changing dates automatically with the computer date 2
Pivot table macro filter data between yesterday and today (date+time) 0
Static Date 1
Excel Vba to change displayed year automatically. 14
Date Formula for number of days between a date and today 7

Back
Top