I am trying to create a formula to return the difference in time between two dates in terms of the number of months and number of days. For example, being age “8 months 3 days.”
This is the formula I came up with so far, but this direction doesn’t get me an accurate return since not every month has exactly 30 days in it:
(DATETIME_DIFF({DATE},‘2 Feb 2020’,‘M’)) & " mos " & ((DATETIME_DIFF({DATE},‘2 Feb 2020’, ‘d’))-(DATETIME_DIFF({DATE},‘2 Feb 2020’, ‘M’))*30) & " days "
Any ideas? Maybe I need to start over using different functions?