Return the date of the Monday in the current week

blank

	A
1	=TODAY() = Saturday 01 November 2025
2	=NOW() = Saturday 01 November 2025 06:36:43
3	=A1-WEEKDAY(A1, 3) = Monday, October 27, 2025
4	=A1-WEEKDAY(A1, 3) = 45957

Built-in Functions

NOW - The date serial number of the current system date and time.
TODAY - The date serial number representing today's date.
WEEKDAY - The day of the week for a given date.

Related Formulas

Return the date of the Monday in the previous week
Return the date of the Monday in the next week
Return the date from a date and time
Return a date in a particular format