answersLogoWhite

0

If you press the Ctrl key and the ; key, it will put in today's date. If you use the Today() function, it will always show the current date when a spreadsheet is opened. So in a cell you just have to put:

=Today()

Then no matter when you open the file it will always have the date of the current day in that cell.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you make cells change color automatically depending on what date is entered in 2007 excel?

Use conditional formatting to set the condition when you enter a particular date.


When you enter a date excel assigns a what value to the date?

numerical


When you enter a date Excel assigns a?

a serial value to the date


In Excel can you highlight columns with a date that is over a year old automatically?

use conditional formatting


Which key do you press to enter the current date in a cell?

Hold down the Ctrl key and press they key with the ; on it. If you do the same while also holding the shift key down, you will get the current time.Ctrl+;


What is an excel function used to enter the system date in a cell in a worksheet?

The NOW function


How do you recover Excel files after a freeze?

You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.


What date was?

Yesterdays date is one minus todays date. By looking at a calendar and finding todays date then looking to the left for yesterdays.


What does the now in Excel mean?

The NOW function puts in the current date and time into a cell. You enter it like this: =NOW()


What is date today of Punjabi?

todays date


What is Punjabi date today?

todays date


What is the date of Punjabi today?

todays date