jcaptchaos2
Well-known Member
- Joined
- Sep 24, 2002
- Messages
- 1,032
- Office Version
- 365
- Platform
- Windows
Hello,
How do I format the second half of this formula to be in date format?
How do I format the second half of this formula to be in date format?
Code:
=IF(ISNA(IF(ISNA(VLOOKUP(G25&"",WIP!B$3:F$539,5,FALSE)),VLOOKUP(H25&"",WIP!B$3:F$539,5,FALSE),VLOOKUP(G25&"",WIP!B$3:F$539,5,FALSE))),"--",IF(ISNA(VLOOKUP(G25&"",WIP!B$3:F$539,5,FALSE)),VLOOKUP(H25&"",WIP!B$3:F$539,5,FALSE),VLOOKUP(G25&"",WIP!B$3:F$539,5,FALSE)))&" "&IF(ISNA(VLOOKUP(F25,'Ship dates - Notes'!F$3:G$704,2,FALSE)),IF(ISNA(VLOOKUP(G25,'Ship dates - Notes'!A$1:B$777,2,FALSE)),"",VLOOKUP(G25,'Ship dates - Notes'!A$1:B$777,2,FALSE)),(VLOOKUP(F25,'Ship dates - Notes'!F$3:G$704,2,FALSE)))