Spreadsheets provide a robust set of date and time functions that you can use to perform various operations. These functions can help you create formulas to calculate durations, determine dates, and display dates and times in the format you want. This guide will take you through the most useful date and time functions in spreadsheets.

TODAY and NOW Functions

The TODAY function returns the current date. It does not require any arguments and can be written as =TODAY(). The NOW function, on the other hand, returns the current date and time. It also doesn't require any arguments and can be written as =NOW().

DAY, MONTH, and YEAR Functions

These functions extract the day, month, or year from a specified date. For instance, if you have a date in cell A1 and want to extract the day, month, or year, you would use:

=DAY(A1) for day =MONTH(A1) for month =YEAR(A1) for year

DATE Function

The DATE function allows you to construct a date by specifying the year, month, and day. The syntax is =DATE(year, month, day). For example, =DATE(2023, 1, 1) would return January 1, 2023.

DATEDIF Function

DATEDIF is a powerful function that calculates the number of days, months, or years between two dates. The syntax is =DATEDIF(start_date, end_date, unit). The unit can be "D" for days, "M" for months, or "Y" for years. For example, =DATEDIF(A1, B1, "D") will return the number of days between the dates in cells A1 and B1.


The TIME function allows you to construct a time by specifying the hour, minute, and second. The syntax is =TIME(hour, minute, second). For example, =TIME(13, 30, 0) would return 1:30 PM.

The HOUR, MINUTE, and SECOND functions, similar to DAY, MONTH, and YEAR, extract the respective time unit from a time or date-time value. For instance, if you have a time in cell A1, you can extract the hour, minute, or second using:

=HOUR(A1) for hour =MINUTE(A1) for minute =SECOND(A1) for second


Mastering date and time functions in spreadsheets can help you streamline your data analysis and data management processes. From simple tasks like extracting the day, month, or year from a date, to more complex tasks like calculating durations or constructing dates and times, these functions provide the tools you need to handle time-related data effectively. As with any other function, practice is key to gaining proficiency, so don't hesitate to explore these functions further on your own.

Text and images Copyright © Spreadsheet Templates

Use of this website is under the conditions of our Terms of Service.

Privacy is important and our policy is detailed in our Privacy Policy.

See the Spreadsheet Templates Cookie Policy for our use of cookies and the user options available.