Forum Discussion
Solved
Need Help Writing Formula To Create Date
Hi Community! I need help creating a formula for a New Column. The result will be a date column based on another date column. What I need to do is check today's date and create a column that...
FourYearsAgoJan1 =
DATE(YEAR(TODAY()) - 4, 1, 1)Example outputs:
Today’s Date Result June 12, 2025 Jan 1, 2021 March 1, 2026 Jan 1, 2022
Hi,
Try this calculated column formula
=date(year(Data[Date])-4,1,1)
Hope this helps.