Macro to return yes or no based on multiple cell dates

[Jimbob12]

I need a macro that based on multiple cell dates determines if the person is qualified or not, and puts yes or no in column A... all of the dates are yearly.

Hope that made sense, thanks for the help

[VBA Noob]

Why not use a formula.

Also to get a proper reply a sample workbook wouldn't go amiss

VBA Noob

[Jimbob12]

ok i have

Please Login or Register  to view this content.

I cant figure out how to make the today() part work, if its possible to do that, ill have what i need...

[VBA Noob]

Maybe

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

VBA Noob

[Jimbob12]

Thank you very much, i got what i need now

[VBA Noob]

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

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

VBA Noob