Data Validation based on Today's Date

[brentong]

I need some help with data validation. Please see the attachment. The receiver of this form fills it out and returns it to me. They enter in goals for the future in rows 31-35, but next weeks goal is the most important. The goal for next week must be the same as SUM(D15,D17,D19,D21,D23,D25). If they are not the same we have problems. The thing is, it needs to be conditional to today. They always fill this out on Mondays and the date that is important is the following Sunday. For Example, if today is May 3, and if the person filling out the space next to May 9th (G32) fills in something other than the SUM(D15,D17,D19,D21,D23,D25), the data validation sign needs to come up and tell them to fix it. However, if they are entering goals for the later weeks, it needs to let it pass, but stop them later when that week comes around. Thanks a bunch for your time and help. I've spent several weeks trying to figure this one out.

[DonkeyOte]

With the following range highlighted: D31:D35 (starting selection from D31)

Apply a Custom Validation rule of:

=AND(C31<>"";IF(TEXT((TODAY()+6-WEEKDAY(TODAY();3));"m/d")=C31;D31=SUM($D$15;$D$17;$D$19;$D$21;$D$23;$D$25);ISNUMBER(D31)))
copy D31:D35 and Paste Special -> Validation over the remaining columns.

(above assumes per your file that the "dates" in columns C, F etc are really text strings following pattern of month/day)

[brentong]

You Rock! Thank you so much. With a little tweaking was able to make that work for a date. I didn't realize I had them in a text format. Thanks again!