Smartsheet formula...

sahilhq

Hi, 

 

Can anyone please advise a formula to calculate the workdays between two dates? I am using the formula below but I don't think it calculates the work days between two dates (Monday-Friday)

=COUNTIFS({Status}, Open, {Proposed Close Out Date}, >=TODAY(), {Proposed Close Out Date}, <=TODAY(14))

Paul Newcome

Try looking into the NETWORKDAYS function.