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
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