Return correct month in text

[Dryver14]

Hi all,

I'm in the UK so 1st march is 01/03/18 ...everyone else is wrong!

Including excel it seems. I am using =text(month(A5),"mmmm") which is returning January.

Strangely =month(A5) returns 3, its the text that's converting it to 1

I've tried =text(month((A5)+3,"mmmm") still produces January

Any Ideas?

 

[Dryver14]

this worked a variation on a theme

=TEXT("1/"&MONTH(L4)&"/1901","mmmm")