Smartsheet formula...

sahilhq
sahilhq ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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))

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!