newbie trouble with formula

  • Thread starter Thread starter jenn k
  • Start date Start date
J

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!
 
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?
 
Thank you Biff! I'm just making sure I understand the existing formulas in
the metrics that we use. I appreciate your help! Thanks.
 
Back
Top