| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for number of years in 750 days
Hi,
Here is one solution =YEARFRAC(--"1/1/09",--"1/1/09"+750,1) An alternative is to use the DATEDIF function, and since you didn't give us a starting date: =DATEDIF(--"1/1/09",--"1/1/09"+750,"Y") whole years =DATEDIF(--"1/1/09",--"1/1/09"+750,"YM") whole months left over =DATEDIF(--"1/1/09",--"1/1/09"+750,"MD") days left over -- If this helps, please click the Yes button. Cheers, Shane Devenshire "wrong way carrigan" wrote: Number of Years Balance of days in Months then days left |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number of days into years/months | Excel Discussion (Misc queries) | |||
| how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
| Number of years, months, days between two dates. | Excel Worksheet Functions | |||
| Converting number of days to years and months | Excel Worksheet Functions | |||
Threaded Mode
