Hi All,
I have a bunch of formulas which use IF statements and conditions involving dates which work great.
For example:
I discovered a slight issue whereby column A contains date and time in the following format ddmmyyyy hh:mm:ss
Lets imagine A2 = 16/03/2022 12:05:10 and we are running the formula now (16/03/2022 22:18), the formula still returns "Valid" when in fact it should return "Expired" due to the time.
It seems that the TODAY() function doesn't take into account the time attached to the date?
How can I overcome this?
Bookmarks