Originally posted by Sebastiaan Kortleven: In what format do you want it? You could divide the current monthnr by 4, skip the rest and add 1 if you just want a number...
Not quite. Dividing by 4 gives one third of a year. Dividing by 3 gives quarters. Still with the above formula, the quarter is wrong for the last month of the quarter (i.e. March becomes the second quarter). Try this to get the current quarter:
The previous quarter then becomes:
Hope this helps,
Tom Blough<br /> <blockquote><font size="1" face="Verdana, Arial">quote:</font><hr>Cum catapultae proscriptae erunt tum soli proscripti catapultas habebunt.<hr></blockquote>