show dates by the week...

  • Thread starter Thread starter andrew v via AccessMonster.com
  • Start date Start date
A

andrew v via AccessMonster.com

Is there a way to show a whole week by dates limiting it to only Mon thru
Fri? Therefore, when the next work week comes along there will be a new
set of dates instead of using

Date(), Date()+1, Date()+2...Date()+4

any suggestions, greatly welcomed. thanks.
 
Is there a way to show a whole week by dates limiting it to only Mon thru
Fri? Therefore, when the next work week comes along there will be a new
set of dates instead of using

Date(), Date()+1, Date()+2...Date()+4

any suggestions, greatly welcomed. thanks.
Click to expand...

DatePart("ww",[DateField])

Look in VBA help for the available arguments for the DatePart
function.
 
Back
Top