=MONTH FORMULA

[Deano]

Hi

If I use the formul =month(today()), I get a result of 11.

Can I modify this formula to bring back a result of November instead of month 11 without creating a list in a range of cells within the workbook?

regards

 

[al_b_cnu]

Hi, Try
MsgBox MonthName(Month(Date))

 

[Deano]

Hi Alan

Appologies for sounding dumb, but I'm not sure how to apply this formula that you are suggesting.

Is it a VBA code or an excel formula? If so, where / how do I use it?

regards

 

[al_b_cnu]

Hi Deano, Sorry - didnt read your post properly

Why not just custom format the date as mmmm or mmm

 

[Deano]

Works Perfectly.
Thanks a million.