Help with Dates

[nealasmothers]

I have a worksheet that is a 7-Day look ahead and I would like it to automatically fill in the dates.

For example:

It shows Monday thru Sunday with the current date beneath it. I would like it to autofill the dates, but when the next day comes it will automatically put the date for the next week.

Days of Week

Monday	11-16-2015
Tuesday	11-17-2015
Wednesday	11-18-2015

Tuesday 11-17-2015 comes around, and Monday would automatically change to 11-23-15.

I have no idea how to accomplish this, any help would be great.

[SureShot]

I will assume the date for Monday is in cell B2 and the date for the remaining dates are in the cells beneath B2.
In cell B2 type the following formula

=IF(WEEKDAY(TODAY(),3)=0,TODAY(),TODAY()-WEEKDAY(TODAY(),3)+7)

In cell B3 type the following formula

=B2 + 1

Copy the formula in B3 down to the bottom of your rows.

[etaf]

i think this may work
=TODAY()+7-WEEKDAY(TODAY()-2)

variation on this
https://exceljet.net/formula/get-fir...efore-any-date

[nealasmothers]

So I manually put the date in under each corresponding weekday. So the dates in the following cells: B3, E3, H3, L3, P3, T3, and X3. All of the dates are manually put in right now. 11-16 to 11-22, what I would like is the worksheet to change the dates as a new day occurs.

[etaf]

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[nealasmothers]

Here is the example that you wanted.

Attachment 430799

[etaf]

see if this works

I have used
=TODAY()+7-WEEKDAY(TODAY()-2)
in the Monday cell
and then for tuesday
MondayCell +1
etc