Thanks, I often get muddled up on how many I actually need!

Wendy

"Pieter Wijnen"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12227-logic-error-on-if-formula.html
..with.norway> wrote in message news:esAz4KqmGHA.2112@TK2MSFTNGP04.phx.gbl...
> Parenthises, Parenthises..
>
> IIf(Weekday(Date(),2)=1,Date()-3,Date()-1) ' 2 = to denote Monday as
> firstdayofweek = vbMonday
>
>
> "Wendy" wrote in message
> news:UcudnXi3_KlDzD_ZnZ2dnUVZ8tydnZ2d@bt.com...
> > Hi
> >
> > I have a formula which should produce yesterdays data if today is
> > tues,wed,thur or fri, if today is monday it should produce fridays data,
> > and
> > sometimes there isn't any data at all.
> >
> > IIf(Weekday(Date()=1),Date()-3,Date()-1)
> > this method works if today is monday.
> >
> > IIf(Weekday(Date()=1),Date()-1,Date()-3)
> > this method works if its tues, wed, thur or fri
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12227
> >
> > Is it possible to get it working for everyday?
> >
> > Thanks
> >
> > Wendy
> >
> >
>
>
>
> --
> ----------------------------------------
> I am using the free version of SPAMfighter for private users.
> It has removed 4079 spam emails to date.
> Paying users do not have this message in their emails.
> Get the free SPAMfighter here: http://www.spamfighter.com/len
>
>