Formula to calculate time between today and a date in the future.

Options

I need to calculate the work days between my "Requested Customer Date" and today, minus two days. This is the formula I currently have, but it's not calculating correctly.

=NETWORKDAYS([Requested Customer Due Date]@row, TODAY()) - 2

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!