Date in VBA for Last Monday to sunday

[papasmurfuo9]

Hi

could someone advise on how to set parameters for the date being last monday to last sunday


so

Paramaters = Date

then i need

ParamatersWeek = the last monday to the last sunday

thank you!

 

[namliam]

date-weekday(date)-5
Yields 20 jul, i.e. your monday, I am sure you can figure the sunday from there.

 

[CJ_London]

with date() being today (31st July)

between dateadd("d",-weekday(date(),vbmonday)-6,date()) AND dateadd("d",-weekday(date(),vbmonday), date())

will give you between 20th July and 26th July