How to create a formula that creates a perpetual weekly date?

[Lo Baan]

I've created a list of weekly dates in 2016 that I use to do a vlookup based off of today's date to input that weekly date into cell B2. Can someone show me if a formula can create a perpetual weekly date instead of me having to update the list for 2017 at the end of 2016?

Thanks, Lo Baan

Example:

 

[NARAYANK991]

Hi ,

What are the dates in A2 , B2 and C2 ?

Always upload a workbook rather than a screenshot.

Narayan

 

[Lo Baan]

Sorry, I have uploaded file for your reference. Thanks, Lo Baan

 

[Lo Baan]

The result I show in B2 is what I use to input into the first tab, "Schedule" to show date for schedule in cell D2.

 

[NARAYANK991]

Hi ,

I am not sure I have understood what you want done.

Suppose a date is entered in A2 , then the first Monday after that date will be :

=A2+7-WEEKDAY(A2,3)

You do not need to create a look up table as has been done in column C.

Narayan

 

[Lo Baan]

Hi ,

I am not sure I have understood what you want done.

Suppose a date is entered in A2 , then the first Monday after that date will be :

=A2+7-WEEKDAY(A2,3)

You do not need to create a look up table as has been done in column C.

Narayan

Thank you so much Narayan. That is why you are an Excel Ninja. I do not have that much understanding of formulas and functions. What you have provided works fantastically!. I was only able to work with what I knew.

Thanks again and really appreciate the help! Lo Baan