Auto-fill todays date when writing

Sebbebond

New Member
Joined
Sep 20, 2010
Messages
14
Hi,

I have a spread sheet with "cases" that I use in work to note tasks that I need to do.

When I start a new case I would like today's date to auto-fill in a specific column, the purpose is to keep track of when I got that task.

Does anyone know how to solve it?

All answers are appreciated, thank you!
Sebastian
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Ron Coderre

MrExcel MVP
Joined
Jan 14, 2009
Messages
2,316
How about just pressing CTRL+;
That will put the current date into whatever you're typing.

Side note: CTRL+,
puts the current time

So you could type:
CTRL+;
SPACE
CTRL+,

to enter the current date and time

Anything there you could use?
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
Hi,

I have a spread sheet with "cases" that I use in work to note tasks that I need to do.

When I start a new case I would like today's date to auto-fill in a specific column, the purpose is to keep track of when I got that task.

Does anyone know how to solve it?

All answers are appreciated, thank you!
Sebastian
See if you can use anything from here:

http://www.mcgimpsey.com/excel/timestamp.html
 

Watch MrExcel Video

Forum statistics

Threads
1,122,780
Messages
5,598,038
Members
414,205
Latest member
Tushark

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top