Last day of month that isn't saturday or sunday

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

Is there a quick formula to look at a date and calculate the last day of
that month that isn't a Saturday or Sunday. Date field is InvDate.

Thanks
Brent
 
Last Day of month is easy. Take the first day of the next month, then
subtract one day. Use DateSerial() to help.
Once that day is known, get the DOW for that day. Use that to determine if
it is a Sat or Sun.
 
Brent said:
Is there a quick formula to look at a date and calculate the last day of
that month that isn't a Saturday or Sunday. Date field is InvDate.
Click to expand...


Try something like:

DateSerial(Year(somedate), Month(somedate) + 1. 0) -
IIf(Weekday(DateSerial(Year(somedate), Month(somedate) + 1.
0), 7) > 2, 0, (Weekday(DateSerial(Year(somedate),
Month(somedate) + 1. 0), 7))
 
Thanks
Marshall Barton said:
Try something like:

DateSerial(Year(somedate), Month(somedate) + 1. 0) -
IIf(Weekday(DateSerial(Year(somedate), Month(somedate) + 1.
0), 7) > 2, 0, (Weekday(DateSerial(Year(somedate),
Month(somedate) + 1. 0), 7))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Weeks in a Month 7
function for date of first and last day through weeknumber 1
workingdays in Acess 2
Calculate Payment Days and Date 3
Last day of month is saturday or sunday? 2
Subtracting Holiday Hours 1
Calculate difference between two dates,but not weekends 3
Saturdays and Sundays 2

Back
Top