SOLVED

If statements with linked data in a cell.

Copper 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 (Copper 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.

1 best response

Accepted Solutions
best response confirmed by DKblack2021 (Copper 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)

View solution in original post