Tracking certifications using If functions

Firebird4646

New Member
Joined
Mar 27, 2018
Messages
2
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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Firebird4646, Good morning.

Try to use:

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

Is that what you want?

I hope it helps.
 
Upvote 0
Firebird4646, Good morning.

You're Welcome.

Glad to have helped you.

Thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,216,095
Messages
6,128,795
Members
449,468
Latest member
AGreen17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top