Dates & Time

Excel formula for First day of the week for a date

Snap any date back to the Monday (or Sunday) that starts its week.

Copy this formula

=A2-WEEKDAY(A2, 2)+1

How the formula works

WEEKDAY(A2, 2) numbers Monday as 1…Sunday as 7; subtracting it and adding 1 lands on that week's Monday. Use type 1 (Sunday = 1) and drop the +1 for a Sunday week start.

Examples

=A2-WEEKDAY(A2, 2)+1→2026-06-22

Monday of the week containing the date.

FAQ

How do I get the end of the week?

Add 6 to the week-start: =A2-WEEKDAY(A2, 2)+7 lands on Sunday.

Related formulas

Get the week number from a date Get the day of the week

Functions used

WEEKDAY

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free