Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have this formula in BG2:
=IF(AND(W2=""),CONCATENATE(TEXT(K2,"m/dd/yy"),CHAR(10),TEXT(O2,"m/dd/yy"),CHAR(10),TEXT(S2,"m/dd/yy"),CHAR(10))) When there are no dates in the referring cells (K2, O2, S2) it returns: 1/00/00 1/00/00 1/00/00 Is there a way to hide this? I already tried leading the formula with: =IF(K2=0,"", which works good until I enter a date (I used 6/13/94) in K2, it retuns: 6/13/94 1/00/00 1/00/00 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I automatically hide columns? | Excel Discussion (Misc queries) | |||
How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel |