Forum Discussion
Solved
If date is between 2 dates from another table return value
I have a DateTable with a list of dates and then I have the table below with fiscal year data: I'm trying to add columns to the DateTable to reflect the data from this fiscal year table....
ryan_mayu It should be noted that the Fiscal Calendar data is coming from a shared Google Sheets doc so that it can be easily accessible for others in the company to update whne needed.
I even tried connecting your sample file to the Google Sheet I'm using for the Fiscal Calendar and I'm having the same issues in your file when I reproduce your formulas with the Google Sheet fiscal calendar. Leads me to believe this has something to do with the originating file.
Finally, I tried using an Excel file for the Fiscal Calendar data instead and I'm still getting the same incorrect results. Perplexing.