# select month from a date (for publishing month - useful for displaying things over time or analysing trends.). Change "DATEVALUE" to the cell reference you want to look the month up from.
=CHOOSE(MONTH(DATEVALUE),"January","February","March","April","May","June","July","August","September","October","November","December")

# banding expectors. change the values in the If statements to change the bandings.
=IF(AA2>100000,"Super Super BB",IF(AA2>60000,"Super BB",IF(AA2>36000,"BB",IF(AA2>25000,"Strong Core",IF(AA2>17000,"Core",IF(AA2>8000,"UN","Dog"))))))

# for spliting out "new" and "old" commissioning systems
=IF(COMMITDATE_CELL>DATE(2013,10,1),"New System", "Old System")