One spot I have not become stuck in however is looking up if a date is within two dates. I have one lookup table which includes a "table-ized" fiscal calendar, and the other has data entered to it on a daily basis. In the data-entry table, I need a column to detect what fiscal week a line-item entry falls into and return a given identifier for it. In Excel, the formula was:
Code: Select all
=IFERROR(LOOKUP(D2,ddWeeks[Week Starting]:ddWeeks[Week Ending],ddWeeks[Week Ending]),"")
I've attached an example to illustrate what I'm referring to, where O2:O4 should return "FY2019-P1-W1". Any advice is appreciated.