trprasad78
Member
Using datedif i able to count the month, but i am not getting expected result.
for example starting date 22-09-2016
End date 20-02-17
in above senor i need the out put as 6 = Sep,Oct,Nov,Dec,Jan,Feb total 6 month
if i use dated if i am getting 4 it count 30 days as month but in my case it has to count even if starting date 30-9-2016 we need to count september one month.
please refer attached file.
for example starting date 22-09-2016
End date 20-02-17
in above senor i need the out put as 6 = Sep,Oct,Nov,Dec,Jan,Feb total 6 month
if i use dated if i am getting 4 it count 30 days as month but in my case it has to count even if starting date 30-9-2016 we need to count september one month.
please refer attached file.
it's working great