Return the date of the monday in the current week
|1||=TODAY() = 02/01/2020|
|2||=NOW() = 1/2/2020 8:58|
|3||=A1-WEEKDAY(A1,3) = Monday, December 30, 2019|
|4||=A1-WEEKDAY(A1,3) = 43829|
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.
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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top