Posted by keith on January 04, 2002 9:53 AM
I have a spreadsheet question. Our company uses a spreadsheet to track all
of it's jobs. I use the following formula to determine what quarter of the
year a jobs falls into (for tax purposes)...
However our year end is really at the end of February, so our book keeper
has mentioned that it would be much easier for her if the formula above was
able to determine what quarter with respect to out year end that job falls
into... Q1 = Mar-May, Q2 = Jun-Aug, Q3 = Sep-Oct, Q4 = Dec-Feb.
Any ideas how this can be done?