Generating Month from Date for Fiscal Calendar

[Christina4]

Greetings,

My data is in the format MM/DD/YYYY and I want to generate the fiscal month and number. Example: Cell contains 7/5/2017 and formula generates 1-Jul. I have tried using the Month and Choose functions. I can get the output to yield the correct month number, but not the correct month name.Thank you for your help!

<tbody>
</tbody>

Christina

 

[Drrellik]

right click on the cell and go to properties under either the date or under custom you can set it to appear however you want. MM/YY MM-YY MM-YYYY

HTH

 

[Christina4]

right click on the cell and go to properties under either the date or under custom you can set it to appear however you want. MM/YY MM-YY MM-YYYY

HTH

Thank you for your response. I must have been unclear. I need both columns of data. I am writing a macro. I need a formula to read the provided date and generate the correct fiscal month and corresponding number.

C D
1 Month Warrant Date
2 =MONTH(D2)-6 7/5/2017

I tried the above formula, but it yields 1-Jan. I need it to say 1-Jul.

 

[Dave Patton]

For Fiscal Year end June 30, July is month 1.

Excel 2010
	A	B	C	D	E	F
1	5-Jul-17	1-Jul	1	Jul	1	7
2	10-Jun-18	12-June	12	Jun	2	8
3					3	9
4					4	10
5					5	11
6					6	12
7					7	1
8					8	2
9					9	3
10					10	4
11					11	5
12					12	6
13
2a

Cell Formulas
Range	Formula
B1	=LOOKUP(MONTH(A1),$E$1:$F$12)&"-"&TEXT(A1,"mmm")
B2	=LOOKUP(MONTH(A2),{1,7;2,8;3,9;4,10;5,11;6,12;7,1;8,2;9,3;10,4;11,5;12,6})&"-"&TEXT(A2,"mmmm")
C1	=LOOKUP(MONTH(A1),E1:F12)
C2	=LOOKUP(MONTH(A2),E2:F13)
D1	=TEXT(A1,"mmm")
D2	=TEXT(A2,"mmm")

 

[Christina4]

For Fiscal Year end June 30, July is month 1.

Excel 2010

	A	B	C	D	E	F
1	5-Jul-17	1-Jul	1	Jul	1	7
2	10-Jun-18	12-June	12	Jun	2	8
3					3	9
4					4	10
5					5	11
6					6	12
7					7	1
8					8	2
9					9	3
10					10	4
11					11	5
12					12	6
13

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

2a​

Worksheet Formulas Cell Formula B1 =LOOKUP(MONTH(A1),$E$1:$F$12)&"-"&TEXT(A1,"mmm") C1 =LOOKUP(MONTH(A1),E1:F12) D1 =TEXT(A1,"mmm") B2 =LOOKUP(MONTH(A2),{1,7;2,8;3,9;4,10;5,11;6,12;7,1;8,2;9,3;10,4;11,5;12,6})&"-"&TEXT(A2,"mmmm") C2 =LOOKUP(MONTH(A2),E2:F13) D2 =TEXT(A2,"mmm") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

YIIPPPEEEE!

Thank you!