A formula for Excel - Queen Marking

[sipa]

For a bit of fun if anyone is into Excel and Bees then the following might be of interest.

Place the following formula in any cell, it will display the correct year marking colour for the current year. It could of course be adapted to show years past or forward. It will automatically update on the change of year.

=IF(RIGHT(YEAR(TODAY()),1)="1","Mark Queens White",IF(RIGHT(YEAR(TODAY()),1)="6","Mark Queens White",IF(RIGHT(YEAR(TODAY()),1)="2","Mark Queens Yellow",IF(RIGHT(YEAR(TODAY()),1)="7","Mark Queens Yellow",IF(RIGHT(YEAR(TODAY()),1)="3","Mark Queens Red",IF(RIGHT(YEAR(TODAY()),1)="8","Mark Queens Red",IF(RIGHT(YEAR(TODAY()),1)="4","Mark Queens Green",IF(RIGHT(YEAR(TODAY()),1)="9","Mark Queens Green",IF(RIGHT(YEAR(TODAY()),1)="5","Mark Queens Blue",IF(RIGHT(YEAR(TODAY()),1)="0","Mark Queens Blue",""))))))))))

Have fun
Sipa

 

[Repwoc]

Shorter version:

="Mark Queens " & CHOOSE(MOD(YEAR(TODAY()),5)+1,"Blue","White","Yellow","Red","Green")

 

[sipa]

Cool.... smarty pants