How to determine Monday date?

new_2_prog

Registered User.
Local time
Today, 13:39
Joined
Aug 4, 2008
Messages
58
What I am looking to do is when todays date is entered, determine what the Monday date of that week is, i.e. Enter todays date 6/21/11 and in another field "Monday Date" 6/20/11 is populated.

Thank you!
 
What I am looking to do is when todays date is entered, determine what the Monday date of that week is, i.e. Enter todays date 6/21/11 and in another field "Monday Date" 6/20/11 is populated.

Thank you!


Something like this maybe?

Code:
dateadd("d", 1 - weekday(date,vbMonday),date)
 
Works perfect, thank you!
 

Users who are viewing this thread

Back
Top Bottom