Can this formula in conditional fromatting be modified to if the 30th day falls on weekends or holidays, it would operate on the next day after the holiday and on Monday after the weekend (unless Monday is a holiday)?
=AND(A1<TODAY()+30,A1>=TODAY())
Thanks