newbie trouble with formula
 

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!
--
jenn k

newbie trouble with formula
 

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?

--
Biff
Microsoft Excel MVP


"jenn k" wrote in message
...
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!
--
jenn k

newbie trouble with formula
 

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


"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"jenn k" wrote in message
...
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!
--
jenn k

newbie trouble with formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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


"T. Valko" wrote:

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?

--
Biff
Microsoft Excel MVP


"jenn k" wrote in message
...
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!
--
jenn k