How to create current and last week as a variable

[#1]

Hi,

I would like to create variables like current week and last week but the value of the variable should be calculated. How to do this??

Thanks for help.

[#2]

Matthias,

here you go:

vCurWeek: Put this in the Value field =Week(Today())

vLastWeek: =Week(Today())-1

Right?

Rainer

[#3 · Accepted solution]

Matthias,

Agree with Rainer, but if want more a format with the year inside, just use WeekName() instead of Week() function.

vCurWeek : =WeekName(Today())

vLastWeek : =WeekName(Today()-7)

[#4]

Thanks a lot.

[Anonymous]

And, if you want to represent it as the date of week start:
=weekstart(today())
=weekstart(today()-7)
Similar for week end. The possibilities are endless.