What would be the solution to not show January

[deciog]

Sirs, Good Morning

Why is January showing for equal to white or zeros

What would be the solution to not show January

only in formulas

thanks in advance

Decio

 

[GraH - Guido]

Perhaps =IF(C3<1,"",TEXT(C3,"mmmm"))

 

[deciog]

GraH - Guido

Yes, it worked, thank you.

using this way

=IF(C3<31,"",TEXT(C3,"mmmm"))

Decio

 

[GraH - Guido]

Why "<31"? Knowing that 31 as date is simply "31/jan/1900"?

 

[Peter Bartholomew]

You could equally limit the accepted dates to this century by using
=IF(C3>36525,TEXT(C3,"mmmm"),"")
[36525 being 100 years + 25 leap years]

 

[deciog]

Peter

Very good solution I loved, I will use this way

Thank you very much

Decio