• 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


  • 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


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.



Excel Ninja
Staff member

If the date is in A1:
Will return the Month No.

Will return the Month