Hello guys,

So in my business, we work Mondays through Saturdays. I need a formula in cell B3 that will help me calculate the number of days (Monday to Saturday) between starting date in B1 and ending date in B2, both starting and ending days inclusive.

This means only Sundays will be exempted. There is a little tweak needed however. We work half day on Saturdays, so I want every Saturday reached to be calculated as half day while Mondays-Fridays are full days.

Kindly help me out gurus in the house.

PS: I will need explanations on the formula so I can replicate it when needed.

Thanks in advance.

Don Adeks.