Microsoft Office Forums - View Single Post - [Solved] Empty date cell shows wrong month & year

Thread: [Solved] Empty date cell shows wrong month & year

View Single Post

Old

06-16-2019, 11:09 AM

Learner7

Learner7 is offline

Learner7 uses Windows XP

Windows XP Learner7 uses Office 2007

Learner7 uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: May 2010

Posts: 51

Learner7 is on a distinguished road

Default

Quote:

Originally Posted by xor

View Post

Isn't just

=IF(ISBLANK(A3),"",TEXT(A3,"mmm"))

Thanks a lot for your support.

Reply With Quote