Formula for Today() to Show if it is a Certain Week Commencing

[ewalker]

Good morning all, i am looking for some assistance if at all possible.

I have a spreadsheet with a list of dates (all Mondays) that represent weeks within a large work planner I am developing.

I am looking for an IF formula that will let me know if “today()” is within a certain week i.e. if today was the 24 October 2018, the cell containing week starting 22 October would be indicated.

Any assistance would be appreciated.

Week Commencing	Current Week (Yes / No)
15 Oct 18
22 Oct 18
29 Oct 18
05 Oct 18

<tbody>
</tbody>

 

[steve the fish]

Hi. Presuming monday is your first day of the week then maybe this:

=IF(AND(A2<=TODAY(),A2+7>TODAY()),"Yes","No")

 

[ewalker]

This is excellent, thanks very much