Forum Discussion

DKblack2021's avatar
DKblack2021
Copper Contributor
Mar 31, 2021
Solved

If statements with linked data in a cell.

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

 

  • DKblack2021 

     

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

2 Replies

Resources