I am not sure how to go about this. I would like to use the calender or
dates to display the result.

For example, we are using 26 pay periods in the year. If 2004-02-10 falls
within period 03/2004 this year, how do I write a formula that determines
which period 2005-02-10 falls under the next year?

Thanks for any help.
Mark

Mark,

What are the rules for the period, for instance is 2004-02-09 in period 03
or 02?

--

HTH

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


"Mark" wrote in message
news:vTYjd.156373$%k.4775@pd7tw2no...
I am not sure how to go about this. I would like to use the calender or
dates to display the result.

For example, we are using 26 pay periods in the year. If 2004-02-10 falls
within period 03/2004 this year, how do I write a formula that determines
which period 2005-02-10 falls under the next year?

Thanks for any help.
Mark