Excel's Date Functions

There are two basic groups of Date functions in Excel - functions that calculate the number of days, months, or years between two dates and functions that can be used to add the current date, time, or day of the week to a worksheet. The tutorials listed below cover both groups.

Excel Date Functions - Adding the Date to a Spreadsheet
The functions listed below can be used to add the current date to an Excel spreadsheet. Each tutorial includes step by step examples of working with dates in Excel.

Excel Date Functions - Calculate the Number of Days Between Dates
Listed here are Excel functions that can be used to count the number of business days between two dates or find the start or end date of a project given a set number of business days. These functions can be very useful for planning and when writing proposals to determine the time frame of a project. Several of the functions will automatically...

Subtract Dates in Excel
There are a number of functions in Excel that can be used to subtract dates. Which one you use depends on whether you want to subtract days, months, or years. The following articles include examples of subtracting two dates in Excel using the different date functions.

Excel DATEDIF Function: Calculate the Difference Between Two Dates in Excel
The DATEDIF function can be used to calculate the number of days, months, or years between two dates.

Excel DATEDIF function Text-only Tutorial
This is a bare bones version of the DATEDIF function tutorial listed above. It is intended for those familiar with using Excel's Date functions.

DATEDIF Function: Calculate Your Current Age
The DATEDIF function can be used to calculate your age in years, months, and days. This tutorial includes a step by step example.

NETWORKDAYS Function: Calculate the Number of Work Days Between Two Dates
The NETWORKDAYS function can be used to calculate the number of working days between two dates in Excel. The function automatically removes weekend days and additional holidays can be removed as well.

The NETWORKDAYS Function Text-only Tutorial
This is a bare bones version of the NETWORKDAYS function tutorial listed above. It is intended for those familiar with using Excel's Date functions.

NETWORKDAYS.INTL Function: Calculate the Number of Work Days Between Two Dates
Similar to Excel's NETWORKDAYS function above, except that the NETWORKDAYS.INTL function can be used for those locations where the weekend days do not fall on Saturday and Sunday. Single day weekends are accommodated as well. This function is only available in Excel 2010.

NETWORKDAYS.INTL Function Text-only Tutorial
This is a bare bones version of the NETWORKDAYS.INTL function tutorial listed above. It is intended for those familiar with using Excel's Date functions. This function is only available in Excel 2010.

The WORKDAY Function: Find the Start or End Date of a Project in Excel
The WORKDAY function can be used to calculate the start or end date of a project for a given number of work days. This tutorial includes a step by step example of using the WORKDAY function in Excel.

The WORKDAY Function Text-only Tutorial
This is a bare bones version of the WORKDAY function tutorial listed above. It is intended for those familiar with using Excel's Date functions.

WORKDAY.INTL Function: Calculate the Number of Work Days Between Two Dates
Similar to Excel's WORKDAY function above, except that the WORKDAY.INTL function can be used for those locations where the weekend days do not fall on Saturday and Sunday. Single day weekends are accommodated as well. This function is only available in Excel 2010.

Excel WORKDAY.INTL Function Text-only Tutorial
This is a bare bones version of the WORKDAY.INTL function tutorial listed above. It is intended for those familiar with using Excel's Date functions.

Excel DAYS360 Function
The Excel DAYS360 Function can be used in accounting systems to calculate the number of days between two dates based on a 360-day year (twelve 30-day months). This tutorial includes an example that calculates the number of days between two dates using the DAYS360 function.

Excel EOMONTH function: Calculate Due Date of an Investment
The EOMONTH function can be used to calculate a due date of an investment that falls on at the end of the month. This tutorial includes a step by step example of using the EOMONTH function to calculate a due date of an investment in Excel.

Excel EDATE Function
The EDATE function can be used to calculate a due date of a project or investment that fall on the same day of the month as the date it was issued. This tutorial includes an example of using the EDATE function to calculate a due date in Excel .

Excel DAY Function
The DAY function can be used to subtract dates in Excel. Find the number of days between two dates. This tutorial includes an example of using the DAY function to subtract two dates in Excel.

Excel MONTH Function
The MONTH function can be used to subtract dates in Excel. Find the number of years between two dates. This tutorial includes an example of using the MONTH function to subtract two dates in Excel.

Excel YEAR Function
The YEAR function can be used to subtract dates in Excel. Find the number of years between two dates. This tutorial includes an example of using the YEAR function to subtract two dates in Excel.

Excel TODAY Function
The TODAY function, one of Excel's date functions, is used to add the current date to a spreadsheet.

Excel NOW Function
The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet.

Excel DATE Function
The DATE function, one of Excel's date and time functions, can be used to add a date to a spreadsheet. This tutorial includes an example of using the DATE function.

Computer Serial Date
Definition of Computer serial date or serial number.

Discuss in my forum

Spreadsheets