Number of working days plus half Saturday

[tek9step]

I am trying to look for a formula that would return the number of working days in the current month including today plus half a Saturday. e.g today date is 10.3.2021 result 8.5 days

also if there was a public holiday on a separate sheet as listed dates e.g 9.03.2021 the result be then 7.5 days

thanks

[Adtxc]

Try this:

=NETWORKDAYS(EOMONTH(TODAY(),-1)+1,TODAY(),Holidays)+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(EOMONTH(TODAY(),-1)+1&":"&TODAY())))=7))/2

[johnmpl]

Hi to both!

If you have the date in A1, you could use this formula:

=NETWORKDAYS(1+A1-DAY(A1),A1,hds)+NETWORKDAYS.INTL(1+A1-DAY(A1),A1,"1111101",hds)/2

hds: Range of holidays. Blessings!