newbie trouble with formula

[jenn k]

Hi all..could you please help me with the following formula?
=if(weekday(B2-1)=1,B2-3,B2-1)
B2 is 7/31/2008. I'm very new at excel, please forgive my lack of
knowledge. Thanks!

 

[T. Valko]

There's nothing wrong with your formula so you'll need to explain the logic
of what you want to do.

Here's what your formula is saying:

If B2-1 = Sunday, subtract 3 days from B2 otherwise subtract 1 day from B2.

Is that what you want it to do?

 

[jenn k]

Thank you Biff! I'm just making sure I understand the existing formulas in
the metrics that we use. I appreciate your help! Thanks.

 

[T. Valko]

You're welcome. Thanks for the feedback!