Explanation
In the image shown, the current date is August 19, 2019.
Excel dates are serial numbers, so you’re able to manipulate them with simple math operations.
TheTODAY functionalways returns the current date.
If either result is FALSE, the AND function will return FALSE.
This test only makes sense if data may include dates in the future, for example forecasts or estimates.
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.
it’s possible for you to format the value returned by TODAY with a datenumber format.
If you need current date and time, use…
