I have a [Due By] date column and a [Monday] checkbox column. I'm trying to create a formula that will check the box on any [Due By] that is a Monday. I got as far as getting the box to check if today is Monday: =IF(WEEKDAY(TODAY()) = 2, 1, 0) But can't figure out the rest. Thanks for your help!