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

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

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.

Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios.

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 …

Jun 8, 2011 · You can quickly find the difference between two dates, control the format of the result, and extend the calculation to a list of dates. For example, you can quickly subtract one …

If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number of days in between both dates. If either one of the date arguments is text, that argument is …

To do this task, you'll use the INT function, or the HOUR, MINUTE, and SECOND functions as shown in the following example. Use the information in the following table in a blank worksheet …

Jun 3, 2002 · Excel can help you calculate the age of a person in different ways. The table below shows common methods to do so, using the Date and time functions. To use these examples …

Feb 8, 2012 · You can add or subtract a number of days, months, or years to or from a date by using a simple formula, or you can use sheet function that are designed to work specifically …