Date query

species8514

Board Regular
Joined
Oct 4, 2006
Messages
98
I have an employee who seems to be incapable of entering todays date correctly in to excel. Obviously killing her would seem to be the simplest solution, however i dont really want to clean up afterwards.

So....

Is there a way of producing a button, which she could click - when she on a certain cell - which would enter the todays date automatically?

The date cant change once it's entered, so i cant just put in NOW, etc. & there are multiple cells on one line which may or may not require the date.

Before you say, she wouldnt remember =NOW even if i glued it to her head....

THX guys.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Mashtonsmith

Board Regular
Joined
Oct 1, 2004
Messages
164
Short of using =today() then paste special as a value, I'm not sure what else would work.
 

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
Yes you could create a special menu button and associate it with a macro. The macro is then:

Code:
Sub EnterDate()

        activecell=format(Date(),"dd-mmm-yy")

End Sub

Of course you can format the date how you want
 

Watch MrExcel Video

Forum statistics

Threads
1,108,507
Messages
5,523,308
Members
409,509
Latest member
CheekyDevil2386

This Week's Hot Topics

Top