Using Date Functions

Contact Us or call 1-877-932-8228
Using Date Functions

Using Date Functions

The three most commonly used date functions are YEAR, MONTH, and DAY. These functions are used to return only the year, month, or day from a date. To use the YEAR, MONTH, and DAY functions:

  1. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
  2. In the Insert Function dialog box:
    1. Search on "Year", "Month", or "Day" or, in the Or select a category drop-down box, select Date & Time.
    2. Under Select a function, select YEAR, MONTH, or DAY.
    3. Click OK.Date Selection
  3. In the Function Arguments dialog box:
    1. In the Serial_number field, enter the cell in which the full date is located.
    2. Click OK.Serial_number Field

Using the NOW and TODAY Functions

Two other date functions are NOW and TODAY. They are useful when you need to show the current date information or need to calculate something based on that information.

  • NOW: Returns the current date and time.
  • TODAY: Returns the current date, but the time is set to 12:00:00 AM.