Skip to main content

Jul 2, 2019, 4:32 AM

Formula for number of working days for last and next calendar month?

Hi Everyone,

Is there any formula for summary formula to calculate

1. Number of working days for last calendar month (20 for June 1 - June 30)

2. Number of working days for last calendar month (22 for August 1 - 31)

Thanks!

5 answers

Loading

Amnon Kruvi (The Architech Club)
Jul 2, 2019, 4:59 AM
And for next month:

ADDMONTHS(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), 2) -
ADDMONTHS(DATE(YEAR(TODAY()), MONTH(TODAY()), 1), 1)

Write an answer...

0/9000