Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate a Date
How would you dtermine a date 2 years into the future and taken to the 1st of
the following month if that date does not occur on the 1st of the month. For example, hire date is 7/18/08 and I want determine a promotion date that is 2 years from the hire date. Then because we only give promotions on the 1st day of the month, the example promotion date would be 8/1/10. What formula would I use to automatically calculate this? New to date functions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions |