I'm looking to write a formula such that the startdate of the year (Jan 1st) is obtained based on the year of the previous month.
For example :
if the input is "2022-01-01" then the formula should return "2021-01-01" (Since year of previous month would be 2021)
if the input is "2022-04-01" then the formula should return "2022-01-01" (since the year of previous month would be 2022)
Thanks in advance !
Solved! Go to Solution.
You can use below formula to get your desired result.
Please let us know if you need more details.