Date Manipulation

[Kyle789]

Hello,

I am hoping someone can help me with some date formulas. As you can see below I have a calendar of dates. At the moment I manually enter the dates below the weekday.

Can someone help me with a formula that shows today's date as well as the next 6 dates in the future?

In the example below, today's date is Sunday June 28, 2020, and the calendar is showing June 28th to July 4. When I open the file tomorrow, the date for Sunday should show July 5.

Thank you for your help!

 

[eduzs]

B3 formula = $e$3+1
C3 formula = b3+1, copy to from C3 to H3.

 

[Kyle789]

B3 formula = $e$3+1
C3 formula = b3+1, copy to from C3 to H3.

Am I doing something wrong?

 

[eduzs]

To enter a formula type this "=$E$3+1"

 

[Kyle789]

It seems were getting closer, but the dates arent correct

 

[Kyle789]

It seems were getting closer, but the dates arent correct

View attachment 17139

in the above picture in only changed Row 3 Col B/C/D

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H
1					28/06/2020
2		Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
3		29/06/2020	30/06/2020	01/07/2020	02/07/2020	03/07/2020	04/07/2020	28/06/2020
Main

Cell Formulas
Range	Formula
E1	E1	=TODAY()
B3	B3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=B2)),"0111111")
C3	C3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=C2)),"1011111")
D3	D3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=D2)),"1101111")
E3	E3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=E2)),"1110111")
F3	F3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=F2)),"1111011")
G3	G3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=G2)),"1111101")
H3	H3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=H2)),"1111110")

 

[Kyle789]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H
1					28/06/2020
2		Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
3		29/06/2020	30/06/2020	01/07/2020	02/07/2020	03/07/2020	04/07/2020	28/06/2020
Main

Cell Formulas
Range	Formula
E1	E1	=TODAY()
B3	B3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=B2)),"0111111")
C3	C3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=C2)),"1011111")
D3	D3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=D2)),"1101111")
E3	E3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=E2)),"1110111")
F3	F3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=F2)),"1111011")
G3	G3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=G2)),"1111101")
H3	H3	=WORKDAY.INTL($E1,--(NOT(TEXT($E1,"dddd")=H2)),"1111110")

That seems to be exactly what I need. Thank you for taking the time to provide me with a solution!

Thanks to eduzs for your input as well.

 

[Fluff]

Glad we could help & thanks for the feedback.