Calc EOWEEK function

The EOWEEK function helps you find the last day of the week for a given date.

Help CentreFunctions & 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

FormulaDescriptionResult
=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.


Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.