Excel dating system
There are several ways to add dates in Excel depending on what exactly you want to do.
For example, do you want to enter a today's date in some report or invoice?
Enter deadline information as it is distributed, such as when projects are assigned.
Resave the tracker with a new name or date and version number, such as Deadline Tracker May2011, each time to keep a running collection of how deadlines are going, or simply save over the original spreadsheet to have an up-to-date single file to review.
You can type a date in an Excel cell in a variety of ways, for example 1/1/2015, or 1-Jan-2015, or 1-Jan, or January 1, 2015.
When you type something like that in a cell, Microsoft Excel knows you are entering a date and automatically applies the date format to that cell.
This article was written by the It Still Works team, copy edited and fact checked through a multi-point auditing system, in efforts to ensure our readers only receive the best information.
To submit your questions or ideas, or to simply learn more about It Still Works, contact us.
Optional: Highlight the headers and click the "Text Color" button, an "A" with a red line under it, to change the color of the headers.Does anyone know how to display the Last Saved Date of an Excel Spreadsheet on one of the worksheets?I have found ways to do it using macros, but the spreadsheet is populated by an add-in called Jet Essentials, and this does not like macros so a solution here must not use one.Excel automatically resizes the column so the entire header fits. Type "Date Started." Press the Tab key and type "Date Submitted." Press the Tab key and select "Date Approved" or "Date Returned." Add additional columns such as "Assigned To" or "Supervisor." Resize the columns as necessary.Click into cell A2, the second cell in the first column.