Todays Date value 1

[Halfcan]

Hello,

Does anyone know how to add a todays date value to excel worksheets?

Thanks,
HC

 

[macropod]

If you input a date into a cell, the date is automatically stored as a number, nominally counting from 1/1/1900 (or 1904, depending on which date system you're using) - the number is simply formatted by excel to look like a date. If you select the cell and format it as general, you'll see the number.

If that's not what you're after, please explain.

Cheers

 

[Halfcan]

Actually, maybe "current date" would be a better term.

I'm looking for a date value that will update by itself, with whatever the current date is.

This is basically for looking at hard copies, so you can easily tell the last time the document was open and/or printed.

Thanks,
HC

 

[Halfcan]

Ok I've figured it out.

You have to edit the Header and Footer sections.

View --> Header and footer

the function to add is: &[date]

HC

 

[bturnerpcg]

If you want the date to update automatically just add "=now()" without the quotes into the cell. After addign this text you will need to format the cell to show how you want it to appear.

 

[01Patrik]

...or

=today()

if you only want the date, no time

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.