Excluding Weekends

[Thompyt]

I want to set up where the date set excludes weekends.

I have code where I set the date for the next day ie: "Tomorrows Issues - " & Date()+1, and I would like it to exclude the weekends. currently if it is a Friday and you get Saturdays date and I need Modays date.

I found this code, but it seems like it would only affect Saturday, not Sunday.

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

How would I adapt this to include both? Or is this completely wrong for my situation?



Thanks
T

[pbaldy]

That's doing the opposite. If it's Monday, it's giving you the previous Friday, otherwise the previous day. You should be able to flip it around.

[NTC]

I believe you are close. Dim Date()+1 with an identity

then check it to be the Weekday value that concerns you

and write the if/then logic to advance the + integer as appropriate

for sanity I would not attempt to put all in one phrase; chop it into discrete identies or if you are using a query set up in a sequence of individual calculated fields

[Thompyt]

I figured it out:

WWeekdays: IIf(Weekday(Date())=7,Format(Date()+2,"mm/dd/yyyy"),IIf(Weekday(Date())=1,Format(Date()+1,"mm/dd/yyyy"),Format(Date(),"mm/dd/yyyy")))