Tom's Hardware > Forum > Applications > Other Software > Excel Date Question

Excel Date Question

Forum Applications : Other Software - Excel Date Question

Tom's Hardware: Over 1.4 million members in 6 different countries available to answer all your high-tech questions. Sign up now! Its free!
Ask the community Add a reply
Word :    Username :           
 
TBlaar   02-16-2006 at 12:34:41 PM

Hello

I have an excel sheet open

In a cell, I wanna insert the date.
Tomorrow, when i open the sheet again, i want tomorrow's date in it.
So basically the date should change every day.

How do I do this?

Any help appreciated.
Thanks

Add a reply
Sponsored Links
Register or log in to remove.
hashv2f16   03-16-2006 at 04:44:39 AM
- 0 +

Hi,

Press F1, type "date", select the first option, there you go

Reply to hashv2f16
TBlaar   03-16-2006 at 01:28:55 PM
- 0 +

hey

Thanks. I actually got the answer about 3 weeks ago, just forgot to post it.

=(TODAY)

in the cell.

Thanks

Reply to TBlaar
hashv2f16   03-17-2006 at 04:35:52 AM
- 0 +

Yeah.. Unfortunately I noticed the publish date of the thread after I had posted. I'm just too used to being on the hardware forums

Reply to hashv2f16
Amk   04-08-2006 at 04:10:30 PM
- 0 +

=now()
=today()

Reply to Amk
Ask the community Add a reply
Tom's Hardware > Forum > Applications > Other Software > Excel Date Question
Go to:

There are 1142 identified and unidentified users. To see the list of identified users, Click here.

Forum map
Bestofmedia Forum ©
2000-2009 Bestofmedia Group
Page generated in 0.383 seconds
Please mind

You are about to answer a thread that has been inactive for more than 6 months.
If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.

Add a reply Cancel
Sponsored links
  • Ask the community now
  • Publish
Ad
Related Topics
See all relatives topics
They won a badge
Join us in greeting them
How do I win badges?