Hi,
One way
Formula:
=EOMONTH(A1,36)+DAY(A1)-TODAY()<0
Check the boundary condition and change <0 to <=0 as necessary.
Hi,
One way
Formula:
=EOMONTH(A1,36)+DAY(A1)-TODAY()<0
Check the boundary condition and change <0 to <=0 as necessary.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks