Trying to use Text and month Function

[Bpgasguy]

trying to use =text(Month(A5),“MMMM”) Just returns January fir everything.This was use in excel

[Hrbrgr]

What is your question?

[karolus]

@Bpgasguy

Just returns January fir everything.

No, it returns “January” for any Date from Februar to December, for Dates in January it returns “December”!

[karolus]

@Bpgasguy

This was use in excel

this use is FALSE also in excel, PLEASE use any DATE-format only for real Dates:

=TEXT(A5;"MMMM") 

[Bpgasguy]

i looked wrong at the excel function that is correct thank you