IF Formula for Today's Date between Two Dates

mtk5200

I'm trying to create a formula that is only triggered when today's date is between two dates. Otherwise, I want it to be blank. I want the dates to be in the cells and not just in the formula. I use this year over year and it will be a lot faster to change them for next year. I get Invalid Operation when I use the dates in cells.

SM The Only Thing I Can Make Work.png

SM What I Want but Gives an Error.png

mtk5200

The dates have to stay along the top as far as I can see because each row is referencing different sheets. So once I get this working, I need to be able to drag across the columns, not down.

ChiEze

Hey, curious to know how you got this working.. Thanks!