The formula uses the AND function to require that both logical tests are TRUE.
In the example shown, the current date is October 30, 2021.
TheTODAY functionreturns the current date on an on-going basis.
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 might format the value returned by TODAY with a datenumber format.
Use a positive value for months to move forward in time, and a negative number…
