Empty date cell shows wrong month & year

xor · #1 06-14-2019, 09:52 PM

Isn't just

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

Learner7 · #2 06-16-2019, 11:09 AM

Quote:

Originally Posted by xor

Isn't just

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

Thanks a lot for your support.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if cell contains date, then month, else blank	Merlot	Excel	7	03-20-2025 08:16 AM
can i make a dropdown style calender to select the month and year to enter vacation time taken	jamesbriese	Excel	1	12-06-2016 01:00 PM
Excel day date month year Function	greginky	Excel	1	01-05-2016 02:19 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM