IF Formula for Today's Date between Two Dates


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!