Auto Fill Date every 30 Days

Tony Barthelemy
✭✭✭✭
Good Day All:
Is there a way to Auto-fill dates? For example:
04/30/18
05/31/18
06/29/18
Thanks
Tags:
Comments
-
You could create the first date in the row... then in the 2nd row add this formula in the date column =[date column name]1 + 30
That will calculate your 2nd date, then you can drag down the bottom-right corner to populate the rest of the dates.
Do note that if that first date disappears or changes it will affect the rest of the dates.
-
Got it, Thanks!
-
You're welcome! Glad I could assist.
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!