DATES

[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?

 

[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

 

[Bob Phillips]

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)

 

[Guest]

That worked pefect! Thank you very much.

Mark

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

 

[Guest]

Awesome, that worked great! Thank you so much.

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