Trying to create a new date based on an existing date minus 12 months.


I have an existing date column [First Commercial Sales Date (Best Case)] and want a new date to be create minus 12 months.

i.e. The [First Commercial Sales Date (Best Case)] date is 22/11/2025 (22 November 2025) and the new date (minus 12 months) should be 22/11/2024 (22 November 2024).

Can anybody help?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!