Thread: Date formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smooney Smooney is offline
external usenet poster
 
Posts: 24
Default 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