Find Month Between two specified date

[Ashhu]

My CreditCard bill dates from 08/mmm/yyyy - 07/mmm/yyyy

I want to fetch Month of trasaction based on above dates.
Ex: if I do any trasaction on 02March2015 , i want formula result to show FEB as month, or

Trasaction from 08Feb2015 should show "FEB" till 07Mar2015
Trasaction from 08March2015 should show "MAR" till 07April2015

Can anyone please help.

-Ashwin

 

[Hui]

Ashwin

If the date is in A1:
=IF(DAY(A1)>=8,MONTH(A1),MONTH(EDATE(A1,-1)))
Will return the Month No.

=TEXT(DATE(YEAR(A1),IF(DAY(A1)>=8,MONTH(A1),MONTH(EDATE(A1,-1))),1),"mmm")
Will return the Month

 

[Deepak]

Check this

=TEXT(DATEVALUE("1-"&IF(DAY(A1)>7,MONTH(A1),MONTH(A1)-1)),"MMM")

 

[Sam Mathai Chacko]

A simple text formula should do the trick

=TEXT(A2-7,"mmm yy")

 

[Ashhu]

Thanks All, Everything is perfectly working