how to find out last week date from current date

[#1]

how to find out last week date from current date

[Miguel_Angel_Baeyens]

Hello,

Use

=WeekEnd(CurrentDate)

Hope this helps

[#3]

this will give the week end days , but i want to know the lask week date , means last date when was friday .

[#4]

try to use this expression: =Date(Num(Date(Now()))-7)

[Miguel_Angel_Baeyens]

Hello,

Use instead

=LastWorkDate(WeekStart(Date(DateFieldName)), 5)

Hope this helps

[#6]

Hi, use this function

weekend

(Date,-1,5)