Empty date cell shows wrong month & year

Learner7 · #1 06-14-2019, 11:27 AM

Hi,

Empty Cell with the date format is showing wrong month & year when it is BLANK.

The formula in B3 & C3 are as below:

=TEXT($A3,"mmm")

=YEAR($A5)

Please support.

Thanks.

NoSparks · #2 06-14-2019, 01:53 PM

Can you post that in a workbook rather than a picture ?

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

Isn't just

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

Learner7 · #4 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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