if & dates

[mahone]

Hi I'm having problems with something that should be simple.

Its regarding expiry dates for training certificates for example:

In B3 would be the issue date in in A2 would be todays date. What I want to happen is for C3 to show either OK, training or expired. Depending on the difference between the dates. Expiry would be 2 years from issue date, training would be from 1 month prior to expiry & OK would be the 23 months prior to that. I hope that makes sense & someone can help.

Thanks

[Steve N.]

Try this...

Please Login or Register  to view this content.

[mahone]

Thanks that works a treat, never used date functions before so wasn't sure where to start, was getting more confused the more I tried & the more I changed things.

Cheers