weeknr previous week

[#1]

Hello,

I want to have the weeknr of the previous week.

How do i do this?

[#2]

Hi Ama,

This will give you the week number for last week:

week(today(2))-1

Is this what you require?

A

[MarcoWedel]

=Week(Today()-7)

or

=WeekName(Today()-7)