1. Technology

Excel DATE Functions

Dates are very important in spreadsheet programs and Excel has a number of date functions. The articles below list a number of date-related tutorials, each or which includes a step by step example of working with dates in Excel 2010.

Date Functions in Excel

There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers the most common date functions used in Excel.

Add Today's Date in Excel

The TODAY function, one of Excel's date functions, can be used to add today's date to a spreadsheet. This tutorial includes a step by step example of using Excel's TODAY function to add today's 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. This tutorial includes a step by step example on how to use the NOW function in Excel.

Calculate the Difference between Dates

Dates are very important in spreadsheets. Not only is it important to add the current date but much of the data stored can be date related - such as the date of purchases or expenditures, the length of term of investments, or the date of scientific observations. The functions listed here can be used to calculate the difference between two...

Count Days Between Two Dates in Excel

The NETWORKDAYS function in Excel 2010 can be used to count the number of working days between two dates. This article includes an example of using the NETWORKDAYS function to count days in Excel.

Count the Number of Days Between Dates in Excel

The DATEDIF function, can be used to count the number of days between dates. This article includes a step by step example of using the DATEDIF function in Excel to count the number of days between two dates.

Calculate the Number of Days Between Dates in Excel

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 a step by step example of using the DAYS360 function in Excel.

Calculate a Project End Date in Excel

The WORKDAY function can be used to calculate the end date of a project for a given number of business days. This article includes an example of using the WORKDAY function to calculate the end date in Excel 2010.

Excel EDATE Function

The EDATE function can be used to calculate a due date of a project or investment that falls 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 the due date of an investment in Excel.
You can opt-out at any time. Please refer to our privacy policy for contact information.

©2014 About.com. All rights reserved.