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
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
Last edited by a moderator: