Hello everyone-

Thanks for your help. All of those formulas work great. I only picked one
and added it to my sheet.

"JE McGimpsey" wrote:

One way:

C12: =C9-1-2*(WEEKDAY(C9)=1)

WORKDAY() is in the Analysis Toolpak Add-in (Tools/Add-ins...)


In article ,
David T wrote:

I need help with a formula/macro. I have a formula that selects cell c9 and
subtracts it by 1 day. If that day is a Sunday, I want the formula to
subtract by 3 days. However, my current formula doesn't subtract by 3.
Please help

C9 : May 21, 2007

C12 =IF(C9-1= "Sunday",C9-3,C9-1)