Return the date of the Monday in the current week

blank


 A
1=TODAY() = Tuesday 01 October 2024
2=NOW() = Tuesday 01 October 2024 06:08:01
3=A1-WEEKDAY(A1, 3) = Monday, September 30, 2024
4=A1-WEEKDAY(A1, 3) = 45565

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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top