not exactly sure what you want to do, but you could use a formula like this,
with the top row (row 3 in this case) being blank, and insert the rows for
the new data at the top.

This formula assumes you want to add up the hours for the last 365 days.
Iput your data in rows 3:26, with blank rows at top and bottom - the dates
are in column B, and the hours in column C.

=SUMPRODUCT(($B$2:$B$27<=TODAY())*($B$2:$B$27=TOD AY()-365)*($C$2:$C$27))

"Marilyn" wrote:

Thanks "damossison"Below is a sample of the columns I also have clums set
for Vacation days, personal days and other. Hope this helps clarify my
question
Personal Illness
Day Date Hours Rolling Actual

Mon 6/5/06 7.50 0.00 7.50
Mon 5/8/06 7.50 0.00 7.50
Fri 4/28/06 4.00 0.00 4.00
Thu 4/20/06 7.50 0.00 7.50
Thu 4/6/06 3.50 0.00 3.50
Fri 1/6/06 7.50 0.00 7.50
Thu 1/5/06 7.50 0.00 7.50
Tue 12/6/05 2.25 0.00 2.25
Thu 12/1/05 7.50 0.00 7.50
Tue 11/15/05 7.50 0.00 7.50
Mon 11/14/05 7.50 0.00 7.50
Mon 9/26/05 7.50 0.00 7.50
Mon 9/12/05 7.50 0.00 7.50
Tue 9/6/05 7.50 0.00 7.50
Mon 7/25/05 7.50 0.00 7.50
Wed 7/6/05 3.00 3.00 0.00
Thu 6/23/05 7.50 7.50 0.00
Wed 6/22/05 7.50 7.50 0.00
Tue 6/21/05 7.50 7.50 0.00
Fri 6/17/05 7.50 7.50 0.00
Mon 5/23/05 3.00 3.00 0.00
Mon 5/2/05 7.50 7.50 0.00
Mon 4/4/05 7.50 7.50 0.00
Fri 4/1/05 7.50 7.50 0.00
99.75
hours left 50.25
days left 6.70
check 150.00


"damorrison" wrote:

Not to sure how you have you spreadsheet, but could you not have two
columns that would add time there and time not there??