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

Advertisements

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top