willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- 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