46 Weeks in the past

I need a formula that looks at todays date and works out what the week number was 46 weeks in the past and a second formula that works out what the date on the Monday of that week 46 week in the past was.

Have been using NOW TODAY WEEKNUM Etc but cant figure it out.

Thanks in advance BVG

This depends on your definition of week number (there are different ones) but you can get 46 weeks ago by using this formula

=TODAY()-46*7

so for weeknumber using WEEKNUM try

=WEEKNUM(TODAY()-46*7)

and for the Monday

=TODAY()-WEEKDAY(TODAY(),3)-46*7

format as date

When you use WEEKDAY with 3 as the second argument it returns a zero for a Monday through to a 6 for Sunday so for any date in A1 this formula will give you the previous Monday

=A1-WEEKDAY(A1,3)

I just used TODAY() in place of A1