ComboBox always contain latest Monday date

[tylerg11]

Hi,

I have a combobox that I use for filtering. I would like it to always default to the most recent Monday as the date. Is there a function or something that makes this possible?

[June7]

Try:
Date - Weekday(Date, vbMonday) + 1

[tylerg11]

Awesome! That works great, thanks. So further, what if I wanted to also query for the dates of previous Mondays?

[June7]

Subtract 7 days to get the previous Monday.
(Date - Weekday(Date, vbMonday) + 1) - 7