extracting quarterly data and having it update daily

[Mailman]

I maintain an Excel 2003 workbook for the USPS. It tracks daily occurences
over the course of the fiscal year. One worksheet keeps a running tally of
the daily input and uses the TODAY function in the condional formatting to
alert trends.

I wish to create a worksheet that keeps a running tally on each quarter but
because I can't enter arguments against TODAY I do not know how to limit the
date range to the quarter...and have it update daily as with the TODAY
function.

Best of the New Year to everyone...

 

[Max]

A sample CF condition to trigger it if the current date is within the 4th Q
(Oct - Dec) would look like this:
=AND(TODAY()>=--"1 Oct 2009",TODAY()<--"1 Jan 2010")
Note that the "<" operator used is intentional as I find it easier NOT to
have to remember what is the last day for the month (30?, 31?, ugh). Any
good? hit the YES below