| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get a runing total for"curent date"or(cell)minus prev 30 days( cel
hello,
Im trying to figure out how to pull a running total for the previous 30 days to the current date, and need it to change daily, i know i might have to change the date everyday or a few small things, but Is there a way to pick a cell and minus the numbers in the prveious 30 cells? and have it auto change everyday?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get a runing total for"curent date"or(cell)minus prev 30 days( cel
use the function =now()-30
"dustin" wrote: hello, Im trying to figure out how to pull a running total for the previous 30 days to the current date, and need it to change daily, i know i might have to change the date everyday or a few small things, but Is there a way to pick a cell and minus the numbers in the prveious 30 cells? and have it auto change everyday?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get a runing total for"curent date"or(cell)minus prev 30 days( cel
Try this
=SUM(INDEX(A:A,MATCH(TODAY(),B:B,0)):INDEX(A:A,MAX (1,MATCH(TODAY(),B:B,0)-30 ))) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dustin" wrote in message ... hello, Im trying to figure out how to pull a running total for the previous 30 days to the current date, and need it to change daily, i know i might have to change the date everyday or a few small things, but Is there a way to pick a cell and minus the numbers in the prveious 30 cells? and have it auto change everyday?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum of total hours not correct | Setting up and Configuration of Excel | |||
| how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
| running total for last 7 calender days | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Linear Mode
