Find Quarter Month From Date In Excel

[Admin]

another one ..

=DATEVALUE(LOOKUP(MONTH(A1),{1,4,7,10},{3,6,9,12})&"/1")

and format the cell

or

=TEXT(LOOKUP(MONTH(A1),{1,4,7,10},{3,6,9,12})&"/1","mmmm")

[Excel Fox]

Nice one with the "/1". An information for posterity: For some non-English languages, you'll always get a January as result. So with a slight modification, the safest bet would be to use a multiplier 29.

[Rick Rothstein]

Nice one with the "/1". An information for posterity: For some non-English languages, you'll always get a January as result. So with a slight modification, the safest bet would be to use a multiplier 29.

Instead of concatenating "/1", couldn't you concatenate "/13" so that it could never be mistaken for a month number no matter the locale?

[Admin]

Instead of concatenating "/1", couldn't you concatenate "/13" so that it could never be mistaken for a month number no matter the locale?

Good point, Rick.