Tracking certifications using If functions

[Firebird4646]

Hello everyone,
I am trying to use If functions to track certifications. I thought this was going to be relatively easy but to be honest I'm stuck. The certification is good for 300 days after that they need to get recertified. The formula works until there is a date that is way our of the range. For example anyone who took the class in 2010 show as qualifie. Here is the function I wrote

=IF(B4-300<=F4,"QUALIFIED",IF(B4+300>="UNQUALIFIED"))

Block B4 has function has the day that they got qualified
Block f4 has =TODAY()+300

Or if there is a better way to compute this I am all ears, thanks and hope you have a great day.

 

[Marcílio_Lobão]

Firebird4646, Good morning.

Try to use:

F4 -->

=IF(B4+300<=TODAY(),"QUALIFIED","UNQUALIFIED")

Is that what you want?

I hope it helps.

 

[Firebird4646]

Firebird4646, Good morning.

Try to use:

F4 -->

=IF(B4+300<=TODAY(),"QUALIFIED","UNQUALIFIED")

Is that what you want?

I hope it helps.

I guess I was making it to complicated, I don't have much experience with excell

 

[Marcílio_Lobão]

Firebird4646, Good morning.

You're Welcome.

Glad to have helped you.

Thanks for the feedback.