show dates by the week...

[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.

 

[fredg]

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.

DatePart("ww",[DateField])

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