What I would like is a calculation that would take return the value of the Thursday before my [TargetDate] value. If it is on a Thursday, it too has to be the Thursday before. This is to make sure that the form is submitted before the target date.

I found this, but looks like I'd have to do a WEEKDAY statement for every day of the week

How to default a date field to a particular day of the week?

Can't seem to wrap my head around this one! Any help would be greatly appreciated!