If I have understood:
=IF(DAY(C1)<15,DATE(YEAR(C1),MONTH(C1),1),DATE(YEA R(C1),MONTH(C1),14))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Cyndy" wrote in message
...
I'm trying to round a date to the first day of the next (14 day) pay cycle
to
show when vacation time is accrued. Right now, I have:

- In cell B6 I manually enter the Date of Hire
- To show when benefits start, 6 months after the date of hire (or 3
months
if hired before 10/1/2005), in cell D6
=IF(B610/1/2005,EDATE(B6,3),EDATE(B6,6))
- To show when vacation is first accrued, 12 months after the benefit
date,
in cell A10 =EDATE(D6,12)

I would really appreciate any help!
Thanks!
Cyndy