days counter

[msword]

Hello. Is there a way to calculate days quantity in the month excluding Sundays?

 

[Fluff]

Do you mean how many days in a particular month excluding Sundays?

 

[tj4242]

Are you looking for a formula? Or VBA? For a formula you can use

=NETWORKDAYS.INTL(startdate, enddate, 11). This will provide the number of working days between the start and end dates. The 11 means only Sundays are weekends per this chart.

https://support.microsoft.com/en-us/office/networkdays-intl-function-a9b26239-4f20-46a1-9ab8-4e925bfd5e2

=NETWORKDAYS.INTL(12/1/22 ,12/31/22 ,11) will give you 27 days in December 2022.

 

[msword]

@tj4242 thanks a lot! this worked like a magic!