I need to subtract 4 days if Tuesday, 3 days if Monday, 2 days if Sunday and
1 day if Saturday. I would like to include this with the formula I'm using
now. (E2-7) the cel the formula is in and the cell i'm subtracting from are
both formated as dates (11/18/09). Can anyone point me in the right
direction?

Thank you,