
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 20, 2022 11:41 PM
I have 2 date columns…
Date 1, Date 2
2020-10-01, 2023-02-01
2019-04-01, 2022-03-31
I’m using the formula specified here to output the difference in years/months…
IF(AND({Date 1}, {Date 2}), DATETIME_DIFF({Date 2},{Date 1}, 'years') & ' years & ' & (DATETIME_DIFF({Date 2},{Date 1}, 'months') - DATETIME_DIFF({Date 2},{Date 1}, 'years')*12) & ' months')
It currently outputs “2 years & 4 months” for Column 1 (correct), and “2 years & 11 months” for Column 2 (incorrect). Column 2 is 1 day off 3 years exactly, and I need a way to round it to the nearest month. Any ideas would be very much appreciated.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 21, 2022 12:07 AM
P.s. the fact that the dates 2021-02-01 and 2023-02-28 display “2 years & 0 months” suggests that months are being rounded down, but instead I want to round up
