Date and Time functions in Canva Sheets
Date and time functions help you work with dates, extract specific components, and calculate time differences. These are useful for tracking events, calculating durations, and formatting dates.
FUNCTION | WHAT IT DOES | EXAMPLE |
DATE | Creates a date value from separate year, month, and day inputs. | =DATE(2024, 3, 20) → March 20, 2024 |
DAYS | Calculates the number of days between two dates. | =DAYS(A2, B2) |
YEAR | Extracts the year from a date. | =YEAR(A2) → 2024 |
MONTH | Extracts the month from a date. | =MONTH(A2) → 3 (March) |
DAY | Extracts the day from a date. | =DAY(A2) → 20 |
DATEDIF | Calculates the difference between two dates. | =DATEDIF(start_date, end_date, unit) |
DAYS360 | Calculates the days between dates using a 360-day year. | =DAYS360(start_date, end_date, [method]) |
EDATE | Returns the date a number of months before or after a start date. | =EDATE(start_date, months) |
EOMONTH | Returns the last day of the month. | =EOMONTH(start_date, months) |
HOUR | Returns the hour from a time value. | =HOUR(serial_number) |
ISOWEEKNUM | Returns the ISO week number. | =ISOWEEKNUM(date) |
MINUTE | Returns the minute from a time value. | =MINUTE(serial_number) |
NETWORKDAYS | Returns the number of working days between two dates. | =NETWORKDAYS(start_date, end_date, [holidays]) |
NETWORKDAYS.INTL | Returns working days between two dates, with custom weekends. | =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) |
SECOND | Returns the second from a time value. | =SECOND(serial_number) |
TIME | Creates a time value from hours, minutes, and seconds. | =TIME(hour, minute, second) |
WEEKDAY | Returns the day of the week as a number. | =WEEKDAY(serial_number, [return_type]) |
WEEKNUM | Returns the week number of the year. | =WEEKNUM(serial_number, [return_type]) |
WORKDAY | Returns the date after a specified number of workdays. | =WORKDAY(start_date, days, [holidays]) |
WORKDAY.INTL | Returns a workday after a specified number of days, with custom weekends. | =WORKDAY.INTL(start_date, days, [weekend], [holidays]) |
YEARFRAC | Returns the fraction of a year between two dates. | =YEARFRAC(start_date, end_date, [basis]) |
Was this helpful?
Helpful
Unhelpful