Hi All,
I am a novice with Excel and I am trying to make a new calendar in Excel that automatically populates some data.
I have created a basic calendar that automatically populates the dates in each cell given the date that is entered in a separate cell.
My issue is used COLUMNS and ROWS to create the formula that automatically populates the cells. This was done with 6 rows and 7 columns.
I want to be able to add 6 more rows for each column so I can add text to the calendar. Before I add the additional rows, the formula works for the cells in the range, but when I add rows it disconnects from the copied formula. Is there a way to redo the formula so it skips from from cell I5 to C11 and so on so the empty cells can be used to add names and other data or is there another way I can go about this?
This is the formula I used for the calendar cells that is just 6 rows and 7 columns:
=COLUMNS($C5:G5)+(ROWS(G$5:G5)-1)*7-$B$6+$B$
Thank you in advance for any help you can give me!
I am a novice with Excel and I am trying to make a new calendar in Excel that automatically populates some data.
I have created a basic calendar that automatically populates the dates in each cell given the date that is entered in a separate cell.
My issue is used COLUMNS and ROWS to create the formula that automatically populates the cells. This was done with 6 rows and 7 columns.
I want to be able to add 6 more rows for each column so I can add text to the calendar. Before I add the additional rows, the formula works for the cells in the range, but when I add rows it disconnects from the copied formula. Is there a way to redo the formula so it skips from from cell I5 to C11 and so on so the empty cells can be used to add names and other data or is there another way I can go about this?
This is the formula I used for the calendar cells that is just 6 rows and 7 columns:
=COLUMNS($C5:G5)+(ROWS(G$5:G5)-1)*7-$B$6+$B$
Thank you in advance for any help you can give me!