Not sure how your data is arranged..Suppose you have the date and overtime
hours Col A and ColB like below

3/11/2009 1
3/12/2009 2
3/13/2009 3
3/14/2009 2
3/15/2009 1

the below formula will return the number of hours applicable as of
today..Today being 13 th the below formula will total the hours after March
13th 2009 which is 2 months back...and the total hours would be 3 (from 14th
mar and 15th mar)

=SUMIF(A1:A4,"" & DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY())),B1:B4)

If this post helps click Yes
---------------
Jacob Skaria


"Resi" wrote:

hi
wonder if you can help me?
I am (still) developing our staff timesheets. i have now been asked if it
would be possible to add a new function based on our new overtime policy. it
means that any overtime taken, should be taken within 2 months. so is anyone
able to figure out how i ask excel to delete overtime automatically so that
for example (here is when myself gets lost):

in May i do 2 hrs overtime.
by the policy i have time until end June to take this time off so excel
should zero the cell that tracks overtime in July BUT only for the hours
taken in May leaving the hours taken in June still to be used up.

does this make sense or have i managed to confuse you as well?

thanks for reading!
Resi

i am using excel 2003 on Windows XP