JWColby
jwcolby at colbyconsulting.com
Mon Jan 15 11:57:38 CST 2007
Has anyone got more efficient code than the following?
Function DteFirstDayOfWeek(dte As Date) As Date
Dim intDOW As Integer
intDOW = Weekday(date, vbUseSystemDayOfWeek)
DteFirstDayOfWeek = date - (intDOW - 1)
End Function
Function DteLastDayOfWeek(dte As Date) As Date
Dim intDOW As Integer
intDOW = Weekday(date, vbUseSystemDayOfWeek)
DteLastDayOfWeek = date + (7 - intDOW)
End Function
John W. Colby
Colby Consulting
www.ColbyConsulting.com