I have the formula for the duration of months between 2 dates. However, I need to add 1 month if the end month days is greater than the beginning month. See below for example;
I tried using EOMONTH, but that doesn't seem to do what I need it to. The following Code goes in the Months Required.
<TBODY>
</TBODY>
I tried using EOMONTH, but that doesn't seem to do what I need it to. The following Code goes in the Months Required.
Code:
=IF([@ECC]=[@EAS],DATEDIF([@EAS],EOMONTH(EASCO,0),"M"),DATEDIF([@ECC],EOMONTH(EASCO,0),"M"))
EASCO= | 19-Mar-19 | |
ECC | EAS | Months Required |
2-Feb-19 | 2-Feb-19 | 1 (needs to be 2 since the day in Mar (19) is greater than the day in Feb (2). |
21-Jan-19 | 5-Feb-19 | 2 (Correct) |
<TBODY>
</TBODY>