Sum cells based on the value (date) of another cell

[Dean_B]

Hi all,

What I am trying to do is count the number of the days worked in the last 14 days. I'm hoping that someone can help me solve how, to sum up, the number of days worked based on the date of another cell. I have got the date cells to highlight in Red if in the last 14 days, but I can't figure out the rest.


I have uploaded the workbook that I am developing.
https://drive.google.com/open?id=1U9Od-KbW8PDyNSLZyT_m0dm-5xjZO1Zn

What I want to do is if the dates in F2:LI2 is 14 days before today, to sum up, the "number of days worked" for each row. So the "Number of days worked in the last 14-day period" column will only ever be 2 cells from the "number of days worked" column

Any help would be greatly appreciated.

Thanks in advance.

Dean

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1065767-sum-cells-based-value-date-another-cell.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).