How to determine Monday date?

[new_2_prog]

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!

 

[DJkarl]

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?

dateadd("d", 1 - weekday(date,vbMonday),date)

 

[new_2_prog]

Works perfect, thank you!