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

Sunday, September 09, 2007

Candy Theme: Money

Chocolate Coins

Gold Mine Gum



Look at all the money related candy. Know any more? I ate about 500 GRAND today in the fun size. Who knew there were so many...I'd be pushing it to add Junior MINTS. Get it, a mint makes money har har...
 
Google Find us on Google+ Website: www.circlephone.com