Return a date if the date falls between two dates
I have two sheets -
Sheet 1 - this includes "Facilities Cycle start date" and "Facilities Due date (EOD)"
Sheet 2 - includes "Request date Simplified"
I need to write a formula in Sheet 2 to get me the "Facilities Due date (EOD)" from Sheet 1 if "Request date Simplified" lies between "Facilities Cycle start date" and "Facilities Due date (EOD)". I have used a couple of different formulas like INDEX/MATCH/COLLECT. I am trying to get the "Facilities Due date (EOD)" in Sheet 2 in the column "Facilities Due Date"
Please note that the actual request date is a auto created when items are entered, the "Request date Simplified" column is a function to simplify the auto number date format.
We have tried using this solution but its hard to refer to what the exact columns are - https://community.smartsheet.com/discussion/69648/index-match-or-vlookup-for-date-range. It is giving the Invalid column value error which indicates that column types are different.
Help Article Resources
Check out the Formula Handbook template!