Need a formula to add/subtract calendar days to a date to create a new date


Smartsheets seems to be defaulting to adding/subtracting business days, but I want the formula to use calendar days instead, how do I do this?

My current formula is =[Planned End Date]1 - 195. But I want it to be 195 calendar days, not business days. How do I change it to be calendar days?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!