Custom Date format in formula

  • Thread starter Thread starter Grant
  • Start date Start date
G

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.
 
Sorry mean't:
="For the months of: " & Format(MENU!B4, "mmm-yyyy")

MENU!B4 is 01/07/04.

Thanks.
 
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
 
Back
Top