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!
Answers
-
Hey @Tanya Brooks
Try
=[Travel End Date]@row + 30
This will add 30days to your travel date
Will this work for you?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!