• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find Month Between two specified date

Ashhu

Active Member
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

Excel Ninja
Staff member
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
 
Top