I am trying to read the attached Excel document and find the row with yesterday’s date (I currently have it set to DateTime.Today.AddDays(-3).ToShortDateString so that it returns 1/20/2020 since that was a holiday) and then return the value of the second column. I can’t figure out why it does not recognize the date. Instead, it just goes through each line and then finishes the process.
Federal Holiday List.xlsx (11.1 KB)