Hello!
So to begin with, another thread titled "COUNTIF anumber of entries in a date range 14-30 days before TODAY?" helped a little, but only with one side of the issue: (Sorry, since this is my first post, no helpful links or images are allowed)
Here is a quick rundown of what I'm trying to do, again I am unable to upload an image, my apologies:
Column A1:A13..............Column B1:B13.............Column C1:C13...........Column D1:D13
DATES...........................START TIME.....................END TIME.................HOURS WORKED( From Columns B and C)
----------------------------------------------------C18 - Date that can be changed per user
--------------------------------------------------------------------------D18 = Data user wants
in D18 I can input this formula:
which works great for counting consecutive days worked (after a day off (0)) up until and including the date on D12.
But D12 isn't the date I want to use, I want the user to be able to specify the date in C18 and then use THAT date to decided where to start the calculation. I can do that with another IF statement below, but I can't nest it into this particular statement or can I?
I can specify a date with this type of formula, but I can't seem to count ONLY consecutive days worked during the set time frame.
Is there a way to combine these formulas or do I need to come up with someone new?
Thanks in advance for any help you can give!
-Jamie
Bookmarks