For a hire date in A1....Try this:

First day of the month after the 6-month period:
B1: =DATE(YEAR(A1),MONTH(A1)+7,1)

earlier of July 1 or Jan 1 after the anniversary date:
C1: =DATE(YEAR(A1)+1,1+(INT((MONTH(A1)-1)/6)+1)*6,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"MarkT" wrote:

I am having trouble finding a way to have a specific date print based off
critera from an employee hire date. I have two future dates that I need to
print, both based off the hire date, one is six months from hire date, the
other is one year from hire date. I am able to calculate the exact dates
just fine, however, the date that I need to print for the one is the first
day of the following month after the six month anniversary, and second is
either July 1 or Jan 1, whichever comes first after the one year anniversary
date.

Can anyone help me in calculating/printing these two dates?