I have a log of employee time worked (date) in A1. Previously, we had paid
employees weekly...but are now migration to the payperiod of the 15th and
30th of the month.

Currently, I have a formula that determined which what pay period and
returned the starting day of week of A1. For example, 4/16/2009 would
return the first day of the pay period (4/13/2009).

=DATE(YEAR([A1]),MONTH([A1]),DAY([A1]))+0.5-WEEKDAY(DATE(YEAR([A1]),MONTH([A1]),DAY([A1])),2)+1

I would now like the formula to return the pay period date for bimonthly
period and return either 3/30/09 (for A1 values 4/8 or 3/31) or 4/15/09 (for
A1 values 4/15 or 4/29). This formula would ideally tackle February as well
if possible...but not required.

Can anyone provide some insights on how this can be accomplished?

Thanks so much!

John G.