Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to have the weeknr of the previous week.
How do i do this?
Hi Ama,
This will give you the week number for last week:
week(today(2))-1
Is this what you require?
A
=Week(Today()-7)
or
=WeekName(Today()-7)