endofweek()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Provides the end of the week containing the date, shifted by an offset, if provided.

Last day of the week is considered to be a Saturday.

Syntax

endofweek(date [, offset])

Learn more about syntax conventions.

Parameters

Returns

Returns datetime representing the end of the week for the given date value, with the offset, if specified.

Examples

The following example returns the end of the week for the specified date.

  range offset from -1 to 1 step 1
 | project weekEnd = endofweek(datetime(2017-01-01 10:10:17), offset)  

Output

The following example returns the end of the week as Sunday for the specified date.

let endofweekSunday = (dateArg: datetime) {
    datetime_add('day', 1, endofweek(datetime_add('day', -8, dateArg)))
};
let data=datatable(Date: datetime, day: string)
[
datetime(2025, 6, 14), "Saturday",
datetime(2025, 6, 15), "Sunday",
datetime(2025, 6, 16), "Monday",
datetime(2025, 6, 17), "Tuesday"
];
data 
| extend SundayEndOfWeek=endofweekSunday(Date)

Output

Related content

• startofweek function
• endofday function
• endofmonth function
• endofyear function
• dayofweek function
• week_of_year function
• ago function