Extract Date for Monday of the previous week

[JamesT1]

Hi guys

Could someone tell me the formula to extract the date for the Monday of the previous week,,, not the current week

many thanks

JT

[Pete_UK]

It would help if you attached a sample Excel workbook, so we can envisage your problem in context.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[BadlySpelledBuoy]

Maybe this:

Please Login or Register  to view this content.

BSB

[Phuocam]

Or try:

=WORKDAY.INTL(A1+1,-2,"0111111")

[samba_ravi]

or
=INT((today()-9)/7)*7+2
or
=INT((today()-8)/7)*7+2 (if your week starts from sunday)

[JamesT1]

many thanks guys

some interesting variation to get the result,, many thanks for your help