willow1985
Wellknown Member
 Joined
 Jul 24, 2019
 Messages
 725
 Office Version

 365
 Platform

 Windows
I have the below formula that indexes column Q. Column Q has dates in it as well as blanks. This formula is working for me with one exception:
If there are blank cells in Q the formula will return the date: 01/00/1900
How can I modify this formula to return a blank if there is a blank in column Q?
=IFERROR(TEXT(INDEX('Manual Log'!Q:Q,MATCH('Parts in Engineering'!A2,'Manual Log'!A:A,FALSE)),"MM/DD/YYYY")&"","")
Any help would be appreciated.
Thank you
Carla
If there are blank cells in Q the formula will return the date: 01/00/1900
How can I modify this formula to return a blank if there is a blank in column Q?
=IFERROR(TEXT(INDEX('Manual Log'!Q:Q,MATCH('Parts in Engineering'!A2,'Manual Log'!A:A,FALSE)),"MM/DD/YYYY")&"","")
Any help would be appreciated.
Thank you
Carla