SUMIF (if) a Date is before a List of Dates

[iilman92]

Hi everyone! I am currently working on a project where I need to identify how much a given employee has accrued vacation based on the hours worked that fall after their accrual start date from a YTD hours list. For example if an employee starts on 1/1/23, they are eligible to begin accruing vacation time 6mo after employment (in this instance it would be 7/1/23). I have two sets of data I'm working with. 1 set is the Employee information with their Accrual Start Date, and the other set of information is their YTD Hours Worked by pay period.

Is it possible to write a formula using SUMIF that says, "From the list of hours worked, sum all of the hours only if the accrual start date is after the check date"?


Operationally I'm trying to write in B2:

1) Use A2 to check the Check Date list.
2) If A2 is before the Check Date, SUMIF

The reason I'm having so much trouble is because if there is an employee who's accrual starts say 3/1/23, the sumif will give me all the hours from 1/24/23 to 12/29/23, however I'm only looking for the hours from 3/1/23 (their accrual start date) to 12/29/23. I hope this makes sense and thank you in advanced for the help!

Screenshot 2024-01-03 184706.png

[Sam Capricci]

so if I'm understanding this, for the person in cell A2 there would be nothing to show in B2 because the accrual start date is before the check date, right?
but the person in A3 has an accrual start date after the check date, so what should the answer be, 45 as shown in F3? What would be the reason to use a sumif formula?
it seems a simple if statement would suffice, something like... =IF(C2>A2,"",F2) dragged down.

[HansDouwe]

Please try in B2 and copy down:

Please Login or Register  to view this content.

[DJunqueira]

This formula could work too:

Please Login or Register  to view this content.

[iilman92]

This worked beautifully, thank you so much!

[HansDouwe]

You are Welcome!

Thanks for the feedback. Glad to have helped. .

If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help