Dear All,
I am trying to get result between two dates for the period from 01.04.2017 to 31.03.2018. Could you pls. help me to resolve. I used the Datedif function but could not acheived. Thanks in advance. You may refer remark for understanding.
Thanks in advance.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I am trying to get result between two dates for the period from 01.04.2017 to 31.03.2018. Could you pls. help me to resolve. I used the Datedif function but could not acheived. Thanks in advance. You may refer remark for understanding.
Thanks in advance.
PERIOD | 01-Apr-17 | 31-Mar-18 | |
Commencement Date | Exit Date | Result | Remark |
28-Nov-13 | 15-Jul-17 | 3 months 15 days | Months calculated from 01.04.2017 to 15.07.2017 |
14-May-17 | 15-May-18 | 11 months 17 days | Months calculated from 14.05.2017 to 31.03.2018 |
28-Nov-13 | 15-May-18 | 12 months | Months calculated from 01.04.2017 to 31.03.2018 |
28-Nov-13 | 12 months | Months calculated from 01.04.2017 to 31.03.2018 since assumed exit date beyond 31.03.2018 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>