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.
Example
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
-
Yes, make the Bill date column a Date-type column. Then you can just use
=[Contract Start Date]@row + 21
Or if the Day Value may change from row to row, you can use
=[Contract Start Date]@row + [Day Value]@row
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
-
I am looking to add 21 days from the contract Start Date to the first Cycle date column.
-
Yes, make the Bill date column a Date-type column. Then you can just use
=[Contract Start Date]@row + 21
Or if the Day Value may change from row to row, you can use
=[Contract Start Date]@row + [Day Value]@row
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!