| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Calculate
I'd like to calculate the number "years" and "months" between a "start date" and "end date". I have a sheet that has the date a person entered our organization and the calculated =TODAY() date. I'd like to then have it converted to number of years and months in the organization.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Calculate
Hi
have a look at http://www.cpearson.com/excel/datedif.htm -- Regards Frank Kabel Frankfurt, Germany "Dennis" schrieb im Newsbeitrag ... I'd like to calculate the number "years" and "months" between a "start date" and "end date". I have a sheet that has the date a person entered our organization and the calculated =TODAY() date. I'd like to then have it converted to number of years and months in the organization. |
| Reply |
| 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 | |||
Hybrid Mode
