Logic Error on If formula

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12227-logic-error-on-if-formula.html
sometimes there isn't any data at all.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12227

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

Is it possible to get it working for everyday?

Thanks

Wendy



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
>
> Is it possible to get it working for everyday?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12227
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12227
>
> Thanks
>
> Wendy
>
>

Parenthises, Parenthises..

IIf(Weekday(Date(),2)=1,Date()-3,Date()-1) ' 2 = to denote Monday as
firstdayofweek = vbMonday


"Wendy" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12227
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

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

Wendy

"Pieter Wijnen"
..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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12227
> > 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
> >
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12227
>
>