Forum Discussion

Copper Contributor

Jan 10, 2018

Solved

Cell-Dependent Formula That Can Skip Cells

I am trying to build a calendar wherein the days automatically update per the current day/month/year, but that the cells adjacent to those numbers are open for content. Here is the formula I ...

Formulas & Functions

Need Help

IngeborgHawighorst
Jan 10, 2018
Hello,

you can insert a column before the first column and between each calendar column. Then the first formula goes into cell B3 and goes like this:

=IF(LEN(B$2)=0,"",IF(MONTH((COLUMNS($A3:B3)/2)+(ROWS(A$3:B3)-1)*7-WDay+FOM)=CMonth,(COLUMNS($A3:B3)/2)+(ROWS(B$3:B3)-1)*7-WDay+FOM,""))

Copy down and across.

The empty cells have the formula, too, but you can overwrite them without destroying anything. Be aware, though, that when the month rolls over, any text that you have manually typed into any cell will still be visible and you will need to clean up the data entries for the new month.

IngeborgHawighorst

MVP

Jan 10, 2018

Hello,

you can insert a column before the first column and between each calendar column. Then the first formula goes into cell B3 and goes like this:

=IF(LEN(B$2)=0,"",IF(MONTH((COLUMNS($A3:B3)/2)+(ROWS(A$3:B3)-1)*7-WDay+FOM)=CMonth,(COLUMNS($A3:B3)/2)+(ROWS(B$3:B3)-1)*7-WDay+FOM,""))

Copy down and across.

The empty cells have the formula, too, but you can overwrite them without destroying anything. Be aware, though, that when the month rolls over, any text that you have manually typed into any cell will still be visible and you will need to clean up the data entries for the new month.