SOLVED

If statements with linked data in a cell.

%3CLINGO-SUB%20id%3D%22lingo-sub-2247079%22%20slang%3D%22en-US%22%3EIf%20statements%20with%20linked%20data%20in%20a%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2247079%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasic%20Excel%20user%2C%20I%20have%20linked%20data%20(dates)%20from%20another%20spread%20sheet.%20The%20linked%20data%20shows%20%220%22%20on%20the%20new%20sheet.%20I%20converted%20the%20cells%20to%20Date%20and%20now%20the%20linked%20cells%20show%20a%20date%20of%20%221%2F0%2F1900%22.%20This%20is%20because%20the%20data%20from%20the%20original%20sheet%20does%20not%20have%20a%20date%20entered.%20How%20can%20I%20write%20an%20IF%20statement%20to%20show%20the%201%2F0%2F1900%20date%20as%20blank%20unless%20there%20is%20a%20date%20in%20the%20original%20linked%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20linked%20data%20string%20pulling%20data%20from%20the%20original%20worksheet%20%3A%3C%2FP%3E%3CP%3E%3D'C%3A%5CUsers%5Cdkb%5CDownloads%5C%5BHDE2900B1.1.xlsx%5DHCM%20-%20Learning%20Transcripts'!Z2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2247079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Good Morning,

 

Basic Excel user, I have linked data (dates) from another spread sheet. The linked data shows "0" on the new sheet. I converted the cells to Date and now the linked cells show a date of "1/0/1900". This is because the data from the original sheet does not have a date entered. How can I write an IF statement to show the 1/0/1900 date as blank unless there is a date in the original linked cell.

 

This is the linked data string pulling data from the original worksheet :

='C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2

 

2 Replies
best response confirmed by DKblack2021 (New Contributor)
Solution

@DKblack2021 

 

=IF('C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2="","",'C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2)

@Hans Vogelaar 

 

Thank you, worked perfectly.