formulae to calculate nth business day for current month

Gaurav Chauhan · 02/06/23

Hi Team,

Which formuale would work best if I need to calculate the nth business day of the current month as of today.

Eg; If today is 6th of Feb, then it is 4th business day

Lets say for next month on 10th of Mar, it would be 8th business day

Can you please help.

Samuel Mueller · 02/06/23

@Gaurav Chauhan try a formula like this

=networkdays(date(year(today()), month(today()),1), today())

Also the today() formula only updates if you open the sheet and save, so refer to this article if you need it to update on it's own

Gaurav Chauhan · 02/13/23

Answers