Mar 31 2021 07:30 AM
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
Mar 31 2021 08:15 AM
Solution
=IF('C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2="","",'C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2)
Mar 31 2021 09:57 AM
Mar 31 2021 08:15 AM
Solution
=IF('C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2="","",'C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2)