Wednesday, September 12, 2007

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?)

No comments:

 
Google Find us on Google+ Website: www.circlephone.com