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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Week Commencing[/TD]
[TD]Current Week (Yes / No)[/TD]
[/TR]
[TR]
[TD]15 Oct 18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22 Oct 18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29 Oct 18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05 Oct 18[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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