Ignoring weekends in days calculation

bhartz

Hi all, I'm attempting to find a formula that allows me to ignore weekends to get an accurate count of how long an assignment is taking. A screenshot of what I'm looking for is below.

I want to take the Date PIC Received - Date PM Assigned and ignore weekends. So in the below example, it should be 1 day since the 23rd was a Friday, and the Assignment was made on Monday.

Dheeraj Goyal

=NETWORKDAYS(Date PIC Received, Date PM Assigned) -1

Dheeraj Goyal

Hi @bhartz

You can use Networkdays() formulae. Subtract 1 since it includes both ends.

bhartz

@Dheeraj Goyal would it look like: =NETWORKDAYS(Date PIC Received, Date PM Assigned, -1)?

I'm not the most versed when it comes to Smartsheet formulas.

Dheeraj Goyal

=NETWORKDAYS(Date PIC Received, Date PM Assigned) -1

bhartz

@Dheeraj Goyal THANK YOU!