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 …

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.

Add or subtract days, months, or years from a date by using a formula or date functions in Excel.

To set the system date, use the Date statement. If you use the Date function with a Gregorian calendar, the behavior of Date$ is unchanged by the Calendar property setting.

To insert the current date or time so that it is updatable, use the TODAY and NOW functions, as shown in the following example. For more information about how to use these functions, see …

To convert a text date in a cell to a serial number, use the DATEVALUE function. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date …

The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.

Jan 1, 2008 · The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.

How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.

Jul 5, 2023 · Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE (2025,5,23) for the 23rd day of May, 2025.