Date difference

[vijayca]

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.

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>

 

[My Aswer Is This]

Using Vba I use something like this:

You can use d for days or h for hours yyyy for year:
Look here for more help:https://www.techonthenet.com/excel/formulas/datediff.php

Sub My_Date()
'Modified  8/23/2018  8:56:05 AM  EDT
aa = "1/1/2018"
aaa = "1/5/2020"
bb = DateDiff("yyyy", aa, aaa)
MsgBox bb
End Sub