Skip to content

Date and Time Functions

Entering Dates and Times

To enter a date in a spreadsheet, use the slash “/” character or dash “-” character.

 

To enter a time, use the colon “:” character.

Date and Time Functions

Many spreadsheet functions interact with dates and times. The functions we will cover in this article include:

  • YEAR
  • MONTH
  • DAY
  • TODAY
  • DATE
  • TIME
  • NOW
  • HOUR
  • MINUTE
  • SECOND

The YEAR Function

The YEAR function requires one argument, and that is any date value. The YEAR function returns the year value of the date.

See the example below.

The MONTH Function

The MONTH function requires one argument, and that is any date value. The MONTH function returns the month number value of the date.

See the example below.

The DAY Function

The DAY function requires one argument, and that is any date value. The DAY function returns the day of the month (1-31).

See the example below.

The TODAY Function

The TODAY function requires no arguments. The TODAY function returns the current date.

See the example below.

The DATE Function

The DATE function requires three arguments. The required arguments include:

  • The year
  • The month number (1-12)
  • The day of the month (1-31)

The DATE function returns the date value of the provided year, month, and day.

See the example below.

The TIME Function

The TIME function requires three arguments. The required arguments include:

  • The hour value (0-23)
  • The minute value (0-59)
  • The second value (0-59)

The TIME function returns the time value of the provided hour, minute, and second value.

See the example below.

The NOW Function

The NOW function requires no arguments. The NOW function returns the current date and time.

See the example below.

The HOUR Function

The HOUR function requires one argument, and that is any time value. The HOUR function returns the hour value of the provided time.

See the example below.

The MINUTE Function

The MINUTE function requires one argument, and that is any time value. The MINUTE function returns the minute value of the provided time.

See the example below.

The SECOND Function

The SECOND function requires one argument, and that is any time value. The SECOND function returns the second value of the provided time.

See the example below.

This Post Has One Comment

  1. I love using the date functions! Using =Today() has saved me so many times! I also like using it in combination with the =TEXT function to get the month automatically spelled out in my worksheet. I use this formula all the time:

    =TEXT(TODAY(),”MMMM”)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top