extracting quarterly data and having it update daily
 

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...

extracting quarterly data and having it update daily
 

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
--
Max
Singapore
---
"Mailman" wrote:
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...