If Tuesday subtract 4 (Formulas)

[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,

 

[Mike H]

Hi,

=E2-CHOOSE(WEEKDAY(E2,2),3,4,0,0,0,1,0)

Mike

 

[Mike H]

I missed Sunday

=E2-CHOOSE(WEEKDAY(E2,2),3,4,0,0,0,1,2)

Mike

 

[Buschwack]

Thanks a lot, worked great.

I missed Sunday

=E2-CHOOSE(WEEKDAY(E2,2),3,4,0,0,0,1,2)

Mike