Thread: [Solved] Empty date cell shows wrong month & year
View Single Post
 
Old 06-14-2019, 11:27 AM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default Empty date cell shows wrong month & year
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.
Attached Images
File Type: png Error.PNG (2.2 KB, 16 views)
Reply With Quote