Search results
Results from the WOW.Com Content Network
You can insert the current date and time in an Excel cell as static values or as dynamic values. A static value is one that doesn’t change when the worksheet is recalculated or opened. A dynamic value is one that is updated each time formulas are recalculated.
The TODAY function returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. If the cell format was General before the function was entered, Excel changes the cell format to Date.
The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
You can use the DATE function to create a date that is based on another cell’s date. For example, you can use the YEAR , MONTH , and DAY functions to create an anniversary date that’s based on another cell.
To enter a date that will update to the current date each time you reopen a worksheet or recalculate a formula, type =TODAY() in an empty cell, and then press ENTER. When you type something like 2/2 in a cell, Excel for the web thinks you’re typing a date and shows it as 2-Feb .
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
To add the current date at the time of printing to the bottom of every printed page, simply insert the date in the worksheet footer. Similarly, you can also add the date to the top of every printed page.
You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel.
As you saw above, the DATEDIF function calculates the difference between a start date and an end date. However, instead of typing specific dates, you can also use the TODAY() function inside the formula. When you use the TODAY() function, Excel uses your computer's current date for the date.
To combine text with a date or time, use the TEXT function and the & (ampersand) operator. Example. The TEXT function requires two arguments (that is, items between its parentheses). The first argument is a value, such as a date or a number. This value is converted to a text value.