How do I return the number of workdays in a month using only the start date?

Dave Bowie

First I had this, worked fine until December

=NETWORKDAYS([start day]@row, DATE(YEAR([start day]@row), MONTH([start day]@row) + 1, 1) - 1)

then i tried this

=IF(MONTH(start day@row) = 12, NETWORKDAYS(start day@row, DATE(YEAR(start day@row), 12, 31)), NETWORKDAYS([start day]@row, DATE(YEAR([start day]@row), MONTH([start day]@row) + 1, 1) - 1))

neither works

Dave Bowie

First I had this, worked great until December went Invalid

=NETWORKDAYS([start day]@row, DATE(YEAR([start day]@row), MONTH([start day]@row) + 1, 1) - 1)

then i tried this

=IF(MONTH(start day@row) = 12, NETWORKDAYS(start day@row, DATE(YEAR(start day@row), 12, 31)), NETWORKDAYS([start day]@row, DATE(YEAR([start day]@row), MONTH([start day]@row) + 1, 1) - 1))

Dave Bowie

@Kelly Moore

see above

Kelly Moore

Hey Dave

In your IF formula, you referenced 'start day' but it doesn't have the square brackets required for a column name containing a space.

This should work for you

=IF(MONTH([start day]@row) = 12, NETWORKDAYS([start day]@row, DATE(YEAR([start day]@row), 12, 31)), NETWORKDAYS([start day]@row, DATE(YEAR([start day]@row), MONTH([start day]@row) + 1, 1) - 1))

Kelly

Dave Bowie

Thank you!

works fine now!

Kelly Moore

Hey Dave

Would you take a screenshot of your formula with the colored text? It would be terrific if it also included your column header for your date field

Thanks,

Kelly