Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically date cell in Excel
We are creating a sheet in Exvel to use as a general form for contrating jobs.
I'm trying to figure out if there is a way to format a cell to automatically enter the day's date when the file is opened. |
#2
|
|||
|
|||
BGS,
In the cell you want the date use: =TODAY() Then you can format the cell to show the date as you want. Everytime you open the file it will input the current days date. Regards, Brian Branch Halo FLight Inc. Non-Profit Air Ambulance Service Corpus Christi, Tx "BGS" wrote: We are creating a sheet in Exvel to use as a general form for contrating jobs. I'm trying to figure out if there is a way to format a cell to automatically enter the day's date when the file is opened. |
#3
|
|||
|
|||
=TODAY()
put the above in the cell in question -- Regards, Peo Sjoblom (No private emails please) "BGS" wrote in message ... We are creating a sheet in Exvel to use as a general form for contrating jobs. I'm trying to figure out if there is a way to format a cell to automatically enter the day's date when the file is opened. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel automatically insert current date in a cell? | Excel Worksheet Functions | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
DOS Data in Excel Format with Date and Military Time in same cell | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Last saved date into an excel cell | Excel Worksheet Functions |