If Tuesday subtract 4 (Formulas)

  • Thread starter Thread starter Buschwack
  • Start date Start date
B

Buschwack

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,
 
Back
Top