Can someone please help me with formulas - I’m terrible at it! I need a formula to say If my column “Initial Contact” is between 1/1/2025 - 12/31/2025, then the value returned is 2025, if 1/1/2024-12/31/2024 will return 2024, and if 1/1/2023 - 12/31/2023 then 2023.
Hey Sarah! Shannon here with the monday team. 
I’d like to offer some help here!
From what you shared, it sounds like you are looking for your formula to return the year for the date entered in “Initial Contact,” is that correct? If so, this formula will achieve just that:
TEXT(YEAR({Initial Contact}),"####")
Rather than setting up a long IF formula to factor in the different date ranges as conditions, we can simplify your formula and ask the column to return the year. Here’s a quick visual of the formula in action:
Let me know what you think! 
Thank you. So much simpler! 
1 Like
Absolutely–no problem at all!