What formula can I use to return a value if the value is in between 2 dates?
I have two sheets. Sheet #1 is a support schedule with columns for every day of the schedule, each column is a dropdown menu column. I extracted the date in text form for each day as shown in the first screenshot. For each day we have different resources assigned in a different column.
In sheet #2, I want to have my resources listed by week and pulled the data automatically. The formula I'm envisioning is something like IF(Day Date coming from sheet #1) is between (Start Date sheet#2) and (End Date sheet#2) then return the name of resource.
My main issues are:
1- The column type where I want to return the value is a contact type.
2- The Day date coming from sheet #1 is not from a date type column and it's an entire row, not a column, so it's text. And the dates I'm trying to compare with are in a date column.
I was thinking that maybe it'll be easier to assign each date a week number since I also have those criteria in my sheet#2 and work with those instead of the between dates. Would this be possible? any ideas on what the formula could look like?
Any help or inspiration would be much appreciated! TIA!
Help Article Resources
Check out the Formula Handbook template!