finding the week dates based on current date

Hi All,

Im trying to return the dates based on the current date. In the spreadsheet (attached) i have months followed by the date ranges that fall into that month, i was hoping there was a simple way of returning the date based on the current date.

e.g.

May
Week 1 01/05/2017 - 05/05/2017
Week 2 08/05/2017 - 12/05/2017
Week 3 15/05/2017 - 19/05/2017
Week 4 22/05/2017 - 26/05/2017

Current date = 23/05/2017

It would hopefully return 22/05/2017 - 26/05/2017

Any help would be greatly appreciated.View attachment Test_book.xlsx

Try array formula:

=INDEX($D$4:$D$29,MATCH(1,(LEFT($D$4:$D$29,10)+0<=$D$1)*(RIGHT($D$4:$D$29,10)+0>=$D$1),0))

confirmed with CTRL+SHIFT+ENTER not just ENTER

=TEXT(TODAY()-MOD(TODAY()-2,7),"dd/mm/yyy") & "-" & TEXT(TODAY()-MOD(TODAY()-2,7)+4,"dd/mm/yyy")
or if the date is in cell A2:
=TEXT(A2-MOD(A2-2,7),"dd/mm/yyy") & "-" & TEXT(A2-MOD(A2-2,7)+4,"dd/mm/yyy")

Note: Of course if today (or the date in A2) is a Saturday or Sunday, then it falls outside your Mon-Fri dates, but you'll still get it showing as within the Mon-Fri leading up to that weekend.