Finding dates and filling after this, days off sheet

[raphaelyp]

Hello guys

I've faced this problem for over a week and I can't solve this...can anyone help me?


exemple.png

This is a worksheet from days off...so I have this starting date and I need to found in the dates (found in many columns) after this...I need to count the days off.
For example.I need some days off...starting day 02/02/2022 and it will be 10 days...So I need to find this date in the columns and then start counting the days until I got 0 days off.

[ben_hensel]

I don't understand what you're asking for.

Are people populating E2:AE100 with tickmarks and you need to count across their row for which days they have marked?

That would be in D2 and pull down:

Please Login or Register  to view this content.

and pull down.

If by days off you just mean the count of days between the two dates next to it in B and C, that is as simple as:

Please Login or Register  to view this content.

Is that what you're asking for?

Also it would help much more to see an attached workbook with samples / dummy data, instead of screencapture image, if possible.