AnsweredAssumed Answered

Format a calculated field

Question asked by Brian Curran on Mar 20, 2018
Latest reply on Mar 23, 2018 by Brian Curran


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.