Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Extracting values from a single dynamic cell to a list daily | Excel Worksheet Functions | |||
update daily sheet | Excel Worksheet Functions | |||
Daily cell update | Excel Discussion (Misc queries) | |||
Update a Date Quarterly | Excel Worksheet Functions |