Get Previous Monday Date Formula

[Brandon]

Hello,

Looking for a formula to get the previous Monday and Sunday dates for default report parameters. I assume something similar to this but cannot get figure it out. 

Formula below is the last day of the year. I can't figure out how to make it previous Monday. 

= Today().AddDays(CDbl(- Today().Day))

 

Thanks in advanced

[Dimitar]

Hello Brandon,

You may try using the following formula to get the previous Monday:

= (AddDays(Today(), - (CInt(Today().DayOfWeek) - 1) - 7)).ToString("MM/dd/yyyy")
 

For the previous Sunday, you may change the highlighted number to 8 in the expression.

I hope this will help.

Regards,
Dimitar
Progress Telerik

[Brandon]

Perfect! That works.

I was looking for the previous Sunday,  our weeks or Monday-Sunday, so highlighted -7 to -1 works.  

= (AddDays(Today(), - (CInt(Today().DayOfWeek) - 1) - 1)).ToString("MM/dd/yyyy")