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?
Help Article Resources
Check out the Formula Handbook template!