Reference List of Dates in Column Relative Today

hildegrant
edited 12/09/19 in Formulas and Functions

Hello! 

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!

Thanks!

Grant

 

Capture.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!