If greater of date1 and date2 is less than todays date display as No??

[N0vice]

Hi all,

As per username I am an excel formula novice.

I am looking to have a column telling me whether my items are currently certified.

Date1 is the previous certificate expiry date, date2 is the new cert issue date (which will be blank until issued/entered - incase that affects date1 v date2 comparison)

Had pictured something along the lines of If greater of (date1 and date2) is less than todays date display as No or vice versa for Yes, but have no idea how to implement it.


Thanks in advance

[TMS]

Something like

Please Login or Register  to view this content.

[N0vice]

Awesome. Thanks for your help.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.