Looking for an easy formula to calculate anniversary off of date column
Wondering if anyone has a quick and easy formula to calculate an anniversary off of a date column?
Photo attached. Essentially, I'm looking for the 2022 Anniversary column to show
I understand if this might not be possible in 2022 since dates have passed, but we're making columns to for the next few years. Is there any formula that can do this? The last time I did a sheet like this, I just copied and pasted the hire date column into the 2022 column and changed the year, but this sheet is over 300 lines, so hoping I won't have to do this manually 😂 Any help is appreciated!
Help Article Resources
Check out the Formula Handbook template!