Date formula
 

What I need is a formula that will tell me the date at 3 months, 6 months, 1
year, etc. from the hire date. Under Annual, it will always be the current
year. If the hire date is more than 2 years, then I only need the annual
date which will be the current year.


Hire Date 3 Month 6 Month 1 Year 18 Month 2 Years Annual
06/30/2009

Thanks

Date formula
 

Have a look in the help index for DATE and then YEAR & MONTH. Combine

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"smooney" wrote in message
...
What I need is a formula that will tell me the date at 3 months, 6 months,
1
year, etc. from the hire date. Under Annual, it will always be the
current
year. If the hire date is more than 2 years, then I only need the annual
date which will be the current year.


Hire Date 3 Month 6 Month 1 Year 18 Month 2 Years Annual
06/30/2009

Thanks

Date formula
 

3 months: =date(year(a1),month(a1)+3,day(a1))
6 months: =date(year(a1),month(a1)+6,day(a1))
1 year: =date(year(a1)+1,month(a1),day(a1))
etc.

Regards,
Fred

"smooney" wrote in message
...
What I need is a formula that will tell me the date at 3 months, 6 months,
1
year, etc. from the hire date. Under Annual, it will always be the
current
year. If the hire date is more than 2 years, then I only need the annual
date which will be the current year.


Hire Date 3 Month 6 Month 1 Year 18 Month 2 Years Annual
06/30/2009

Thanks

Date formula
 

Hi,

Check the EDATE function in the Help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"smooney" wrote in message
...
What I need is a formula that will tell me the date at 3 months, 6 months,
1
year, etc. from the hire date. Under Annual, it will always be the
current
year. If the hire date is more than 2 years, then I only need the annual
date which will be the current year.


Hire Date 3 Month 6 Month 1 Year 18 Month 2 Years Annual
06/30/2009

Thanks