Convert date:
=DATE(2021,9,1)
Count business days:
=NETWORKDAYS(DATE(2021,9,1), DATE(2021,9,30))
Count business hours:
=MULTIPLY(NETWORKDAYS(DATE(2021,9,1), DATE(2021,9,30)),8)
Photo by Annie Spratt on Unsplash
Convert date:
=DATE(2021,9,1)
Count business days:
=NETWORKDAYS(DATE(2021,9,1), DATE(2021,9,30))
Count business hours:
=MULTIPLY(NETWORKDAYS(DATE(2021,9,1), DATE(2021,9,30)),8)
Photo by Annie Spratt on Unsplash