I have a date field which I want to display as month/year only OR leave it blank.

I've managed to get this to work

=TEXT(Date,"mmmm")&" "&YEAR(Date)

but how do I add a line saying that if the date field is blank, leave it blank?

It is defaulting to putting in December 1899.


Not the best way, but it works for me.

=IF(YEAR(Date)=1899;" ";YEAR(Date)&"/"&MONTH(Date))
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.