# DATES

G

#### Guest

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?

G

#### Guest

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

B

#### Bob Phillips

MarkT said:
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,

=DATE(YEAR(A2),MONTH(A2)+7,1)

and second is
either July 1 or Jan 1, whichever comes first after the one year anniversary
date.

=DATE(YEAR(A1)+1,(INT((MONTH(A1)-1)/6)+1)*6+1,1)

G

#### Guest

That worked pefect! Thank you very much.

Mark

Ron Coderre said:
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

G

#### Guest

Awesome, that worked great! Thank you so much.

Bob Phillips said:
=DATE(YEAR(A1)+1,(INT((MONTH(A1)-1)/6)+1)*6+1,1)