Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The EOWEEK function helps you find the last day of the week for a date.
Syntax
EOWEEK(date)
The EOWEEK function syntax has the following arguments:
- date Required. Dates should be entered either by using the "YYYY-MM-DD" format or by using the DATE function, or as results of other formulas or functions.
Example
| Formula | Description | Result |
| =EOWEEK(2020-10-05) | Date of the last day of the week. | 2020-10-11 |
| =EOWEEK(2021-06-22) | Date of the last day of the week. | 2021-06-27 |
Errors
For a full list of formula errors, please read Formula errors.