adjust date calculation formula to count calendar days instead od workdays


Hi -

I have 2 date fields:

  • Travel End Date - entered manually
  • REIM DUE DATE – needs to be “Travel End Date +30 calendar days”

The formula below works but it counts 30 workdays after Travel End Date.  

How to I correct it to be 30 calendar days after Travel End Date?

=WORKDAY([Travel End date]@row, +30)

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!