#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Can you post that in a workbook rather than a picture ?
|
#3
|
|||
|
|||
Isn't just
=IF(ISBLANK(A3),"",TEXT(A3,"mmm")) |
#4
|
|||
|
|||
Thanks a lot for your support.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
if cell contains date, then month, else blank | Merlot | Excel | 4 | 10-03-2016 03:27 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 |