Custom Date format in formula

[Grant]

Hi there,

I am trying to acheive something like the following:

="For the months of: " & Format(MENU!B4-12, "mmm-yyyy")

However with no luck.
How might I get this to work?

Thanks in advance for the replies,
Grant.

 

[Frank Kabel]

Hi
what is in cell B4 (and why are you subtracting 12?)

 

[Grant]

Sorry mean't:
="For the months of: " & Format(MENU!B4, "mmm-yyyy")

MENU!B4 is 01/07/04.

Thanks.

 

[Gord Dibben]

Grant

="For the months of: " & TEXT(MENU!B4,"mmm-yyyy")

Since only one month will be returned maybe alter to "month"

Gord Dibben Excel MVP