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
:)