# of days in a pay-period based on qualifying dates

Hello,

First time posting, hoping to get answer

I have set of qualifying dates for few states and a pay-period with its own set of dates.

I need to find number of days within the pay-period for each states based on qualifying dates. # of days in Pay-period cannot exceed more than 10 days.

Please see attachment, Thank you

HI,
can you give an example of what answer do you expect to see in cell G2 for example, and why?
Need to know the logic you are seraching for....Thanks.

Hi ,

Thanks for replying. I am trying figure out state lockdown days related to covid 19 for a particular pay-period.

In cell G2 I should see 10 days (excluding weekends) and G3 I should see 8 days (excluding weekends) and similary on G5 i should see 1 day

Thank you!

OK, and can you expalin how do you get to 10 days in G2? What did you do to get to 10? I'm still not sure that the goal is understood.

Thanks.

So the pay period dates falls within CA qualifying dates. If you exclude weekend in the pay period qualifying days would be 10 day. Hope this helps. Thank you

so you're looking for the overlapping days excluding weekends?

Yes, that would give me the # of qualifying days within the pay period

amazing! Thank you. Can you see how Can I get value to return as 0 for pay-period if dates doesn't fall within the pay-period. I have added to more rows.
Thank you

Thank you, you are amazing!

You're welcome.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved.