- Jan 14, 2016
- Office Version
My file has a list of dates covering the last 5 years in column B. Next to each date in column C is the number of working hours for the date listed in column B. I would like Excel to search B:B and look for dates that include today's date (shown in cell A2) and all other dates within the last 365 days. I then need to know a sum of the working hours listed in C:C that relate to the dates from B:B within the search range of today -365 days.