VBA, Date of Monday actual week

Date of Monday actual week

Author	Message
RZ #1 / 2	Date of Monday actual week Hi, Does anybody knows a function that can returns the date of Monday of actual week ? Example this week the function should returns 9/3/2001 Thanks for help RZ
Sun, 22 Feb 2004 04:37:16 GMT

Douglas J. Steel #2 / 2	Date of Monday actual week Something like DateAdd("d", vbMonday - Weekday(Date()), Date()) should do it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele Quote: > Hi, > Does anybody knows a function that can returns the date of Monday of actual > week ? Example this week the function should returns 9/3/2001 > Thanks for help > RZ
Sun, 22 Feb 2004 04:59:56 GMT

Page 1 of 1

[ 2 post ]