Checking a Date Range
I am trying to figure out which type of formula I would use to allow my project plan to display the correct information for a certain date. My attempt that I keep doing is to use an IF formula to compare the date ranges in the Column with the Today function to see if any are less than or equal to Today's date. If they are less than or equal to today's date then it would simply output the description for that specific range. My problem is having it figure out which is the correct date range to pull the information for. Any help on this would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!