| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to look at current date and markdown date to give price | Excel Discussion (Misc queries) | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Linear Mode
