EOWEEK formula? require something similar to EOMONTH for a weekly basis

[Newport Count]

Hi,

I use the following formula to work out the start (cell A1) and end dates (cell A3) of the previous month, which works perfectly:

cell A1: =EOMONTH(A2,-2)+1
cell A2: =TODAY()
cell A3: =EOMONTH(G4,-1)


I'm trying to do something similar on a weekly basis, but there is no EOWEEK function! I need to display the Monday of the previous week in cell A1 and the Sunday of the previous week in cell A3, based on the current date in cell A2.


Many thanks,
Rich

 

[Special-K99]

Try

Previous Monday
=A2-MOD(A1-2,7)-7
Previous Sunday
=A2-MOD(A2-2,7)-8

Generate some dates and test if it's works.

 

[Newport Count]

thanks Special-K99!

I amended your formula to the following (which now works perfectly):
Previous Monday
=A2-MOD(A2-2,7)-7
Previous Sunday
=A2-MOD(A2-2,7)-1

I really appreciate your help - thank you!