Just wanted to post this in case any poor soul runs into the same issue as I did and can't find a solution.
For some reason Excel doesn't like it when you type dates into a formula. I have a table where I'd like to return a few values based on the dates in an adjacent column. To do this, I used an IFS formula, . For some reason, this will always evaluate the first logical test: as true, no matter what date is in C14.
I tried putting the dates in quotes so the equation read . But then it would just evaluate everything as if the second logical was true. (Ie. It put "Winter 2019" for everything.
I found a workaround was to put the dates in their own cells, and reference the cell, as opposed to typing the date in manually. So the formula now read where the value in E5 was 3/1/2019 and F5 was 7/1/2019.
Similarly, if the dates are written inside the formula with the DATE function, it works as well.
Bookmarks