Date & Time Functions¶
Current Date/Time¶
| Function | Syntax | Example | Description |
|---|---|---|---|
| NOW | NOW() |
=NOW() |
Current date and time |
| TODAY | TODAY() |
=TODAY() |
Current date |
Date Construction & Extraction¶
| Function | Syntax | Example | Result |
|---|---|---|---|
| DATE | DATE(year, month, day) |
=DATE(2025, 6, 15) |
June 15, 2025 |
| YEAR | YEAR(date) |
=YEAR(A1) |
Year component |
| MONTH | MONTH(date) |
=MONTH(A1) |
Month (1-12) |
| DAY | DAY(date) |
=DAY(A1) |
Day (1-31) |
| HOUR | HOUR(time) |
=HOUR(A1) |
Hour (0-23) |
| MINUTE | MINUTE(time) |
=MINUTE(A1) |
Minute (0-59) |
| SECOND | SECOND(time) |
=SECOND(A1) |
Second (0-59) |
| WEEKDAY | WEEKDAY(date, [type]) |
=WEEKDAY(A1) |
Day of week (1=Sunday) |
| WEEKNUM | WEEKNUM(date, [type]) |
=WEEKNUM(A1) |
Week number of the year |
Conversion¶
| Function | Syntax | Example | Description |
|---|---|---|---|
| DATEVALUE | DATEVALUE(date_text) |
=DATEVALUE("2025-06-15") |
Converts text to date serial number |
| TIMEVALUE | TIMEVALUE(time_text) |
=TIMEVALUE("14:30:00") |
Converts text to time serial number |
Date Arithmetic¶
| Function | Syntax | Example | Description |
|---|---|---|---|
| DATEDIF | DATEDIF(start, end, unit) |
=DATEDIF(A1, B1, "D") |
Difference in days ("D"), months ("M"), or years ("Y") |
| EDATE | EDATE(start_date, months) |
=EDATE(A1, 3) |
Date shifted by N months |
| EOMONTH | EOMONTH(start_date, months) |
=EOMONTH(A1, 0) |
Last day of the month, N months away |
| DAYS | DAYS(end_date, start_date) |
=DAYS(B1, A1) |
Number of days between two dates |
| DAYS360 | DAYS360(start, end, [method]) |
=DAYS360(A1, B1) |
Days between dates using 360-day year |
| NETWORKDAYS | NETWORKDAYS(start, end, [holidays]) |
=NETWORKDAYS(A1, B1) |
Working days between dates |
| WORKDAY | WORKDAY(start, days, [holidays]) |
=WORKDAY(A1, 10) |
Date after N working days |