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.

[TABLE="width: 827"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]PERIOD[/TD]
[TD]01-Apr-17[/TD]
[TD]31-Mar-18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Commencement Date[/TD]
[TD]Exit Date[/TD]
[TD]Result[/TD]
[TD]Remark[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]28-Nov-13[/TD]
[TD]15-Jul-17[/TD]
[TD]3 months 15 days[/TD]
[TD]Months calculated from 01.04.2017 to 15.07.2017[/TD]
[/TR]
[TR]
[TD]14-May-17[/TD]
[TD]15-May-18[/TD]
[TD]11 months 17 days[/TD]
[TD]Months calculated from 14.05.2017 to 31.03.2018[/TD]
[/TR]
[TR]
[TD]28-Nov-13[/TD]
[TD]15-May-18[/TD]
[TD]12 months[/TD]
[TD]Months calculated from 01.04.2017 to 31.03.2018[/TD]
[/TR]
[TR]
[TD]28-Nov-13[/TD]
[TD] [/TD]
[TD]12 months[/TD]
[TD]Months calculated from 01.04.2017 to 31.03.2018 since assumed exit date beyond 31.03.2018[/TD]
[/TR]
</tbody>[/TABLE]

 

[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