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

 

[James006]

Hi,

As an initial step ... since you are using Excel ... you should make sure to use actual dates ... and not Text ... like in a word processor ...

Your life will become a lot easier ... since you will be able to use formulas ... and fully automate your worksheet ... :wink:

 

[Dean_B]

Hi James,

Can you please explain how/where I am not using actual dates?

Cheers,

Dean

 

[James006]

Hello,

Can always post you an updated version of your spreadsheet ...:wink:

Why is your structure of Six Columns for every week .... broken ONLY for Weeks 28-31 ???