What I am looking for is a way to set a cell value based on the date in another being within the current week. For example...
Cell D2 value is Aug/15/2012, I want a formula that will set check to see if the date value in D2 is within the current week (8/12 - 8/18) , then set cell E2 = G2, if the date value IS NOT within the current week, then set E2 = $150.00.

Can this be done?