Reference List of Dates in Column Relative Today
I have a project I am working on where I've created a little bit of a manual schedule that I'm integrating into a smarter excel sheet, but I'm struggling with a formula to duplicate information.
I've attached a screenshot below of my spreadsheet... what I need to have happen is this:
I would like to have a formula reference column "Date" and search for the date that is within 3 days of today's date (auto update as a week goes on), and place the applicable date from column "Date" into a specific cell in Column "1". I feel like I'll need to use the FIND command, but its asking me to reference text instead of a date, and I'm not able to get a search for this data to read cleanly.
Any feedback or assistance would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!