Either showing : empty or blank
My nice working formula is :
=text(A1,"mmmm")
It gives me the name of the month(in B) depending on the date in A
When A is blank then it gives 'January' in B.
WONDERING if the result in B can be either nothing(blank) or the word "empty"
when A is blank or have no values.
If somebody knows both ways, I'll be gratefull to learn it. Thanks
|