Date and time functions in Canva Sheets

FUNCTION

WHAT IT DOES

EXAMPLE

DATE

Creates a date value from separate year, month, and day inputs.

=DATE(2024, 3, 20) → 20 March 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])