Formula to calculate Fiscal Month starting on January

[SriniML]

Hi -

Fiscal year in my company for 2012 started on 2nd of Jan 2012.
Fiscal year in my company for 2013 started on 31st of Dec 2012
Because, our fiscal week always starts on a Monday.

I'm trying to calculate fiscal month number for any given date between 2012 and 2013.
Please help me write a formula for this.

Eg:
Aug 3rd 2013, should be part of Fiscal Month 7.
Aug 5th 2013, is when Fiscal Month 8 would get started.

Regards
Srinivas

 

[Matty]

Welcome to MrExcel!

Maybe:

=MONTH(A2-WEEKDAY(A2,3))

Matty

 

[SriniML]

Welcome to MrExcel!

Maybe:

=MONTH(A2-WEEKDAY(A2,3))

Matty

================
Matty -

Thank you so much, your formula almost worked . Per our calendar,

In 2013, Per our calendar, Fiscal Month 1 started on 31st of Dec 2012. Per your formula, it starts on 7th Jan 2013.
In 2013, Per our calendar, Fiscal Month 10 started on 30th of Oct 2013. Per your formula, it starts on 7th Oct 2013.

I'm guessing, this is because our calendar must have been customized.. but if could let me know if i can do anything using a formula or if you would know any other alternate - it would be great.

Thank again
Srini

 

[SriniML]

It worked for all other months btw, i should have mentioned this.

 

[Matty]

If all other months work, except for the one mentioned, then I'm not sure what calendar is being used.

Could you provide a list of all the Mondays where the Fiscal Month changes?

Matty