Auto-fill todays date when writing

[Sebbebond]

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

 

[Ron Coderre]

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]

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

 

[Sebbebond]

See if you can use anything from here:

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

Great, both solutions work fine but this second one was the one I was looking for. Thank you!

 

[T. Valko]

Great, both solutions work fine but this second one was the one I was looking for. Thank you!

Good deal. Thanks for the feedback!