Weekday excluding weekends

[jd316632]

I have a query that pulls data from a Due Date column based on the date. I want to see what I missed from yesterday.



However on Monday it shows me Sunday. I want it to instead skip Saturday/Sunday and use Friday if it is Monday but I cannot for the life of me accomplish this. I've used Google and attempted to use Weekday, DatePart and VBA code but cannot get something that seems to simple to work.

• The Due Date field is in date/time format (1/1/2010 4:30 PM) I have it formatted to just the date as it made pulling the data based on the criteria easier (Format([Due Date],"mm/dd/yyyy")
• The criteria currently used with the Due Date field is Format((Date())-1,"mm/dd/yyyy")

If you need any additional information please let me know. Thanks in advance for any assistance.

[kimmer]

IIf(Weekday(Date())=6,Format(Date()-3,"mm/dd/yyyy"),Format(Date()-1,"mm/dd/yyyy"))

[jd316632]

IIf(Weekday(Date())=6,Format(Date()-3,"mm/dd/yyyy"),Format(Date()-1,"mm/dd/yyyy"))

Not returning any data, for Friday I had 20+ due.

[kimmer]

oops! change the 6 to a 2. sorry.