Set a formula for a whole table based on the next nonempty cell to the left

[OGGY67]

I am trying to set up a schedule sheet made up of a set of dates based on the first column.
It would be easy, just adding the number of days as in this example, but from the second column there may be some empty cells and this varies each time a new schedule is set up. I don't want to use code, I would like to use functions so that anyone can modify it in case it is needed. Somebody said using INDEX and MATCH function I can do it, but I don´t get it. Any ideas?
1 A B C D
2 date =(A1+$A$7) =(B1 +$A$7) =(C1 +$A$7)
3 date =(A2+$A$7) =(B2 +$A$7)
4 date =(A3+$A$7) =(B3 +$A$7) =(C3 +$A$7)
5 date =(A4+$A$7) =(B4 +$A$7) =(C4 +$A$7)
6 date =(A5+$A$7) =(B5 +$A$7)
7
8 #days

 

[OGGY67]

Correction to the previous post because I can't edit it.
1-- A ---------B-------------- C-------------- D
2 date =(A2+$A$8) =(B2 +$A$8)
3 date =(A3 +$A$8) =(C3 + $A$8)
4 date =(A4+$A$8) =(B4 +$A$8) =(C4 +$A$8)
5 date =(A5+$A$8) =(B5 +$A$8)
6 date =(A6+$A$8) =(B6 +$A$8) =(C6 + $A$8
7
8 #days

 

[Peter_SSs]

Welcome to the MrExcel board!

You have had nearly 20 people look at you post and no replies. I suspect the other viewers, like me, don't really understand what you have and what you are trying to do.
Can you post some sample data and expected results with XL2BB and explain again in relation to that new sample data?

 

[bebo021999]

I re-draw the whole picture follow what to be displayed. What is your expected outcome for this:

Book1
	A	B	C	D
1
2	01-Jan	11-Jan	21-Jan
3	02-Jan	12-Jan	22-Jan
4	03-Jan	13-Jan	23-Jan	02-Feb
5	04-Jan	14-Jan	24-Jan
6	05-Jan	15-Jan	25-Jan	04-Feb
7
8	10
Sheet1

Cell Formulas
Range	Formula
B6:D6,B5:C5,B4:D4,B2:C3	B2	=A2+$A$8
A3:A6	A3	=A2+1

 

[OGGY67]

I re-draw the whole picture follow what to be displayed. What is your expected outcome for this:

Book1
	A	B	C	D
1
2	01-Jan	11-Jan	21-Jan
3	02-Jan	12-Jan	22-Jan
4	03-Jan	13-Jan	23-Jan	02-Feb
5	04-Jan	14-Jan	24-Jan
6	05-Jan	15-Jan	25-Jan	04-Feb
7
8	10
Sheet1

Cell Formulas
Range	Formula
B6:D6,B5:C5,B4:D4,B2:C3	B2	=A2+$A$8
A3:A6	A3	=A2+1

Thank you for your help
Everything moved the second I posted it, the row numbers are incorrect, I can´t install the XL2BB on this computer and also it won´t let me edit the post!
I will try again: If the cell to the left is empty, the formula should consider the next cell that is not empty to give you a new date based on $A$7.
Now my formulas are basically these, all different and I have to change them manually (empty cells may vary each time).
I need one formula for the whole table (it is huge) that anyone can just fill it down and then set the empty cells where needed, considering empty cells between them could be more than one. It would save tons of time for me and my team.
-- A ---------B----------- C------------ D-------------E
1 date =(A1+$A$7)--------------- =(B1 +$A$7) =(D1 +$A$7)
2 date =(A2 +$A$7)----------------------------- =(B1 +$A$7)
3 date =(A3+$A$7) =(B3 +$A$7) =(C3 +$A$7) =(D1 +$A$7)
4 date =(A4+$A$7)--------------- =(B4 +$A$7) =(B1 +$A$7)
5 date =(A5+$A$7) =(B3 +$A$7) =(C5 +$A$7) =(B1 +$A$7)
6
7 #days

 

[OGGY67]

I re-draw the whole picture follow what to be displayed. What is your expected outcome for this:

Book1
	A	B	C	D
1
2	01-Jan	11-Jan	21-Jan
3	02-Jan	12-Jan	22-Jan
4	03-Jan	13-Jan	23-Jan	02-Feb
5	04-Jan	14-Jan	24-Jan
6	05-Jan	15-Jan	25-Jan	04-Feb
7
8	10
Sheet1

Cell Formulas
Range	Formula
B6:D6,B5:C5,B4:D4,B2:C3	B2	=A2+$A$8
A3:A6	A3	=A2+1

Thank you, this is what i meant to post:
-- A ---------B----------- C------------ D-------------E
1 date =(A1+$A$7)--------------- =(B1 +$A$7) =(D1 +$A$7)
2 date =(A2 +$A$7)----------------------------- =(B1 +$A$7)
3 date =(A3+$A$7) =(B3 +$A$7) =(C3 +$A$7) =(D1 +$A$7)
4 date =(A4+$A$7)--------------- =(B4 +$A$7) =(D1 +$A$7)
5 date =(A5+$A$7) =(B3 +$A$7) =(C5 +$A$7) =(D1 +$A$7)
6
7 #days

 

[OGGY67]

I am trying to set up a schedule sheet made up of a set of dates based on the first column.
It would be easy, just adding the number of days as in this example, but from the second column there may be some empty cells and this varies each time a new schedule is set up. I don't want to use code, I would like to use functions so that anyone can modify it in case it is needed. Somebody said using INDEX and MATCH function I can do it, but I don´t get it. Any ideas?
1 A B C D
2 date =(A1+$A$7) =(B1 +$A$7) =(C1 +$A$7)
3 date =(A2+$A$7) =(B2 +$A$7)
4 date =(A3+$A$7) =(B3 +$A$7) =(C3 +$A$7)
5 date =(A4+$A$7) =(B4 +$A$7) =(C4 +$A$7)
6 date =(A5+$A$7) =(B5 +$A$7)
7
8 #days

I better post an image

 

[OGGY67]

Welcome to the MrExcel board!

You have had nearly 20 people look at you post and no replies. I suspect the other viewers, like me, don't really understand what you have and what you are trying to do.
Can you post some sample data and expected results with XL2BB and explain again in relation to that new sample data?

I just posted a new correction and an image of the table. I can´t install XL2BB on my laptop. I need this so badly. Thank you!

 

[OGGY67]

I am trying to set up a schedule sheet made up of a set of dates based on the first column.
It would be easy, just adding the number of days as in this example, but from the second column there may be some empty cells and this varies each time a new schedule is set up. I don't want to use code, I would like to use functions so that anyone can modify it in case it is needed. Somebody said using INDEX and MATCH function I can do it, but I don´t get it. Any ideas?
1 A B C D
2 date =(A1+$A$7) =(B1 +$A$7) =(C1 +$A$7)
3 date =(A2+$A$7) =(B2 +$A$7)
4 date =(A3+$A$7) =(B3 +$A$7) =(C3 +$A$7)
5 date =(A4+$A$7) =(B4 +$A$7) =(C4 +$A$7)
6 date =(A5+$A$7) =(B5 +$A$7)
7
8 #days

Here is an image on the table, but formula is very complicated, so I simplified it. I only care about the way you can identify the next cell is empty or not to consider it as a base for the next date.

 

[OGGY67]

Thank you for your help
Everything moved the second I posted it, the row numbers are incorrect, I can´t install the XL2BB on this computer and also it won´t let me edit the post!
I will try again: If the cell to the left is empty, the formula should consider the next cell that is not empty to give you a new date based on $A$7.
Now my formulas are basically these, all different and I have to change them manually (empty cells may vary each time).
I need one formula for the whole table (it is huge) that anyone can just fill it down and then set the empty cells where needed, considering empty cells between them could be more than one. It would save tons of time for me and my team.
-- A ---------B----------- C------------ D-------------E
1 date =(A1+$A$7)--------------- =(B1 +$A$7) =(D1 +$A$7)
2 date =(A2 +$A$7)----------------------------- =(B1 +$A$7)
3 date =(A3+$A$7) =(B3 +$A$7) =(C3 +$A$7) =(D1 +$A$7)
4 date =(A4+$A$7)--------------- =(B4 +$A$7) =(D1 +$A$7)
5 date =(A5+$A$7) =(B3 +$A$7) =(C5 +$A$7) =(D1 +$A$7)
6
7 #days

I posted an image of the table on my first post. Thank you!