Return the date of the monday in the current week

 A
1=TODAY() = Wednesday 01 June 2022
2=NOW() = Wednesday 01 June 2022 05:41:48
3=A1-WEEKDAY(A1,3) = Monday, May 30, 2022
4=A1-WEEKDAY(A1,3) = 44711

Built-in Functions

NOW - The serial number of the current system date and time.
TODAY - The 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


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