Date Formulas


I am looking to set up a Date function.

I have multiple dates on a sheet, I need to set a column or multiple columns up with a formula to automatically calculate.


1 column has a Start date (date column property)

I want another column to calculate 21 days ahead when that will bill, and so on for each 21 days..

Do I make the bill date column a Date property?

What is the formula I use, I have searched but can only find =Date2 =21 which doesn't work because I have multiple dates on a line I need the formula to grab a specific column and count forward.

Thank you for your help and suggestions in advance

Michelle Lambert

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!