Hi Karen,

Not sure I've got your data structure, but how about

=SUM(M2:OFFSET(M2,,MONTH(TODAY())-1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Karen D" <Karen wrote in message
...
Hi,

I am trying to develop a vacation time tracker which will accrue time
earned. This company accrues time based on anniversary date, not at the
beginning of the year. I have already set up columns for each pay period,
that calculate how much time should accrue for that time period only.
Now,
what I want to do is, based on the cell that holds todays date, figure out
how far out to go on the columns and sum those amounts for just the
columns
that fall in the correct time period.

For example,

Column M holds the accrual amount for each employer for the pay period
beginning on 1/1/05. I want a formula that compares that pay period date
to
the current date, and if it is less than the current date, add the amount
in
Column M, then go on to column N and do the same thing. The problem I'm
running into is that I can only go 7 levels on the if formula, but I have
24
columns to look at.

Can anyone help me out?

Thanks!
Karen
:)