Converting Dates Into a 4-4-5 Calendar Format

[Jambi46n2]

Hello,

The company I work for goes by the 4-4-5 Financial Calendar.

I found a formula that will Convert a DATE to the MONTH of 4-4-5

=MATCH(A1-DATE(YEAR(A1),1,0),{0,29,57,92,120,148,183,211,239,274,302,330})

A1 Being a DATE example: 1/31/2013
B2 Results in Displaying the 4-4-5 MONTH: 2

Can anyone help me make B2 Result in Showing The Year and Month?

Maybe even putting the year into C2
as Excel doesn't really accept 02/2013 without making it 02/01/2013

Any help would be greatly appreciated!

Thanks so much!

 

[CalcSux78]

Did a quick search for Excel 4-4-5 calendar and got this post: See post #4

Excel 2010
	A	B
1	Date	Month
2	1/1/2015	1
3	1/30/2015	2
4	2/26/2015	2
5	2/27/2015	3
Sheet1

Cell Formulas
Range	Formula
B2	=MATCH(A2-DATE(YEAR(A2),1,1),{0,29,57,92,120,148,183,211,239,274,302,330})

 

[CalcSux78]

my apologies... correct formula is =TEXT(DATE(YEAR(A4),MATCH(A4-DATE(YEAR(A4),1,1),{0,29,57,92,120,148,183,211,239,274,302,330}),1),"mmmm yyyy")

 

[Jambi46n2]

Awesome!!

Much nicer than the method I was using previously.
To get around it I was creating 4 additional columns with formulas to display the Month and Date.

=TEXT(DATE(YEAR(A2),MATCH(A2-DATE(YEAR(A2),1,0),{0,29,57,92,120,148,183,211,239,274,302,330}),1),"mmmm yyyy")

Replacing the 1 with a 0 in the formula seemed to be more accurate as the start of the week lands on a Friday.

Thank you so much!!
I can now create a button to press using VBA for everyone to use at will.
You made life a hell of a lot easier for me and my entire team here at work!