Getting a previous Monday (unless the date is a Monday)

[Berandon]

I saw a thread that asked for the prior Monday formula, but i used it and if the date is a Monday it goes to the previous Monday, How would i change the formula to be if Monday is today then leave it. I am new to using days of the week formula, so any explanation of how the formula breaks down so i can use it for other days of the weeks i may need. I mostly need previous Monday and following Friday and i have a working Friday one, but not the Monday one.

Thank you in advance for any help.

 

[arthurbr]

Perhaps =today()-WEEKDAY(today(),3)

 

[shg]

	A​	B​	C​
1​	Mon 01 Jan 2018​	Mon 01 Jan 2018​	B1: = A1 + 1 - WEEKDAY(A1 - 6 - 2)
2​	Wed 10 Jan 2018​	Mon 08 Jan 2018​
3​	Fri 02 Mar 2018​	Mon 26 Feb 2018​
4​	Sun 11 Mar 2018​	Mon 05 Mar 2018​
5​	Tue 13 Mar 2018​	Mon 12 Mar 2018​
6​	Mon 12 Mar 2018​	Mon 12 Mar 2018​

For the on-or-prior nDay,

= A1 + 1 - WEEKDAY(A1 - 6 - nDay)

For Monday, nDay is 2

 

[offthelip]

assuming that E3 contains "=Today()"
then :
=E3-WEEKDAY(E3-1)+1

 

[Tetra201]

If your Excel has the WORKDAY.INTL function, here is a shorter formula:

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

 

[Berandon]

Thank you all for the awesome suggestions. I got it working perfectly.