# Convert days to years and months

#### h3lpme

##### New Member
Hello

In column H5 I have a date of 25/03/2011 and in column I5 I have the formula =TODAY()-H5 so this shows the number of days as 2085. How can I change it so it shows the number in years and months or even just years? Its a spreadsheet that shows employees years of service.

Thanks for any help

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### AlanY

##### Well-known Member
Hello

In column H5 I have a date of 25/03/2011 and in column I5 I have the formula =TODAY()-H5 so this shows the number of days as 2085. How can I change it so it shows the number in years and months or even just years? Its a spreadsheet that shows employees years of service.

Thanks for any help

divide that by 365.25 will give you the years, i.e 5.708 years

will that be enough?

#### steve the fish

##### Well-known Member
This will give you years:

=DATEDIF(H5,TODAY(),"y")

or use "m" if you want months. Or "ym" if you want months ignoring years.

#### Macropod

##### Retired Moderator
Try:
=DATEDIF(H5,TODAY(),"y") &" years, "&DATEDIF(H5,TODAY(),"ym")&" months"

Last edited:

#### h3lpme

##### New Member
Thanks for everyones help. Didnt expect it so quick

Macropod your formula was perfect, thank you

Replies
2
Views
79
Replies
2
Views
158
Replies
17
Views
347
Replies
19
Views
323
Replies
3
Views
53

1,195,903
Messages
6,012,206
Members
441,681
Latest member
AkosiJessica

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back