Thread: 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??

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

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" <dustin@discussions.microsoft.com> wrote in message
news:B490259D-9E96-469B-9978-E22CEF0B35EE@microsoft.com...
> 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??
>
>