We’re rewarding the question askers & reputations are being recalculated! Read more.
1

In the end =COUNTIF($B1:$B100,"month")>1 worked, no quotation marks. I thougth I tried it before


1

I think the relative and absolute reference would help you with this. There are 3 types of them: $A1 Allows the row reference to change, but not the column reference. A$1 Allows the column reference to change, but not the row reference. $A$1 Allows neither the column nor the row reference to change. In your case, I think you only want the column ...


1

This should do the trick: and(today()>start_date,today()<end_date)


1


Only top voted, non community-wiki answers of a minimum length are eligible