Dynamically Changing Named Ranges

[pzeitlin]

I have a model that has hours worked by person by period. Today's
date looking back is actuals and today's date looking forward is a
forecast. What I need to do is provide a cum total of hours worked to
date (omitting forecasting).

I've done it before, but my brain is fried - so help would be great.
What I'd like to do is create a named dynamic range that expands based
on date change.

i.e.

Today 12/15/07

Col - A B C D
Row
I
1 12/07 12/14 12/21 12/28
2 John 5 4 3 5
3 Bill 1 2 2 1
4 Adam 3 4 4 2

sumif(a1:today) basically......

Thanks..help is tremendously appreciated. Probably use indirects and
matchs..but can't think anymore.

v/r

PAZ

 

[Marcelo]

try it

http://www.ozgrid.com/Excel/Dynamic...8A37!Rk5HUFxtY2c6Zm5ncDpwXI/d6EOhMa+wLs+i7KkR

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"(e-mail address removed)" escreveu:

 

[pzeitlin]

try it

http://www.ozgrid.com/Excel/DynamicRanges.htm?cf89AACA96=166B28A37!Rk...

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"(e-mail address removed)" escreveu:








- Show quoted text -

Thanks! I saw this during searches..but didn't pay close enough
attention..this should do the trick.