Your Daily Piece of Excel Code

What I did for my Summer Camp (Air Force Reserve annual tour) today: wrote Excel code of course!

=IF(ISBLANK(H6),NA(),DATE(YEAR(H6)+1,MONTH(H6),DAY(H6)+1))

If H6 is blank, then put #NA in this cell otherwise add 1 yr, and one
day to H6 and put it here.

Today's likely capper:

=IF(ISBLANK(Test!I6),NA(),IF(TODAY()>Test!I6,"No",IF(TODAY()>Test!I6-90,
"<90d","Yes")))

If it's blank print NA, otherwise run that nested IF statement and say someone's current, has less than 90 days currency remining, or is noncurrent.

It was kind of fun.

(Sick, isn't it?)