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!