The "Duration" format in Numbers_09 seems to work for weeks, days, and smaller increments of time. I am trying to get the display function to show years and months. This is for autocalculations of ages for birthdays, but would be also useful for the length of time between recurring events (colonoscopies?). How to do this?
MacBook Pro with Retina display, OS X Mountain Lion (10.8.2), 15-inch, Mid-2012, 16GB, 2.6 GHz i7
you can enter two dates and subtract them to get duration directy. In your case you can use the function datedif() like this:
D2=DATEDIF(B2,B3,"Y")&"Years "&DATEDIF(B2,B3,"YM")&"Month(s)"
this is shorthand for in cell D2 type (or copy and paste) the text
"=DATEDIF(B2,B3,"Y")&"Years "&DATEDIF(B2,B3,"YM")&"Month(s)""
without the first and last double quotes
enter the start date in D2 and then end date in B3
you can enter two dates and subtract them to get duration directy. In your case you can use the function datedif() like this:
D2=DATEDIF(B2,B3,"Y")&"Years "&DATEDIF(B2,B3,"YM")&"Month(s)"
this is shorthand for in cell D2 type (or copy and paste) the text
"=DATEDIF(B2,B3,"Y")&"Years "&DATEDIF(B2,B3,"YM")&"Month(s)""
without the first and last double quotes
enter the start date in D2 and then end date in B3
How do I display durations as years and months?
