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

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

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