I have used the following formula to calculate the number of days from when a contract started until today:
The above returns 413 days based on a contract start date of 01st Feb 2017. I would like to format so that it reads as follows:
1 year, 1 month and 20 days
Ideally, I would like to show the year, month and day in singular and plural depending on the number. For example:
05th Aug 2002 =
15 years, 7 months and 16 days.
Any suggestions on where/how to do this would be great.