Previous Week Start and End Date

[Anonymous]

Hi I am trying to get previous week item counts, I was able to get the counts however having difficulty to capture previous week start date and previous week end date(week start from Sunday). I am trying with below expression but both returning current week start and end dates. Please advise. 

Last Week Start Date = Today()-Weekday(Today()-1)+1

Last week End Date =  Today()-Weekday(Today()-1)+7

I am expecting the result 4/25/2021 - 5/1/2021

Appreciate for help.

[richbenmintz · Accepted solution]

Hi @Anonymous,

Try the following

Last Week Start Date = (Today()-WEEKDAY(TODAY())+1)-7

Last Week End Date = (Today()-WEEKDAY(TODAY())+1)-1

Thanks,

[sayaliredij · Accepted solution]

Hi You can check the following formula

FirstDayOfLastWeek =

var daynum = TODAY()

RETURN

daynum - (6 + WEEKDAY(daynum) )

LastDayOfLastWeek =

var daynum = TODAY()

RETURN

daynum - WEEKDAY(daynum)

Regards,

Sayali

If this post helps, then please consider Accept it as the solution to help others find it more quickly.

[richbenmintz · Accepted solution]

Hi @Anonymous,

Try the following

Last Week Start Date = (Today()-WEEKDAY(TODAY())+1)-7

Last Week End Date = (Today()-WEEKDAY(TODAY())+1)-1

Thanks,

[TAMOREIRA]

This is exactly what I needed and the missing parathensis from the original post is still tripping me. As in, why does the extra parathensis return the start of the week?