Explanation
In the image shown, the current date is August 24, 2019.
Excel dates are serial numbers, so they can be manipulated with simple math operations.
TheTODAY functionalways returns the current date.
This is based on aformula described herewhich gets the Monday of the current week.
Once we have that date, we subtract 14 days to get the Monday two weeks prior.
The second logical test simply checks if the date is less than Monday in the current week.
when both results are TRUE, the AND function will return TRUE.
If either result is FALSE, the AND function will return FALSE.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
The TODAY function takes no arguments.
you’re able to format the value returned by TODAY with a datenumber format.
By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.
you could use the WEEKDAY function inside other formulas to check the day of week.
