If statement
Typo:
=IF(TEXT(C9-1,"ddd")="Sun",C9-3.C9-1)
Should be:
=IF(TEXT(C9-1,"ddd")="Sun",C9-3,C9-1)
Format as DATE
Biff
"T. Valko" wrote in message
...
Here's one way:
=IF(TEXT(C9-1,"ddd")="Sun",C9-3.C9-1)
Biff
"David T" wrote in message
...
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)
|