B
Bill
Hi All,
I have a problem with the cell display if a dependant cell is empty. I have
a date tracking spreadsheet. It tracks the date visits were made to clients.
At the top, I have Week of (cell A2) to (cell C2) to display the week start
and end dates. The week runs Mon to Sun. The first blank is cell A2 and the
user must enter a date, the second blank, cell C2 contains =A2+6 to display
the end of the week date.
I then have 7 columns, one for each day of the week. Monday thru Sunday. I
am trying to get the date to display below each day of the week based on the
entry in cell A2. So I have entered in the cell below Monday, =a2; below
Tuesday, =a2+1; etc. It works fine with a date in cell A2. However, if the
contents of cell A2 are blank (deleted), the cells below Monday displays as
1/0, Tuesday as 1/1, etc. I would like blank or empty cells displayed for
the dates if the contents in cell A2 is deleted or blank.
Any help is appreciated.
Bill
I have a problem with the cell display if a dependant cell is empty. I have
a date tracking spreadsheet. It tracks the date visits were made to clients.
At the top, I have Week of (cell A2) to (cell C2) to display the week start
and end dates. The week runs Mon to Sun. The first blank is cell A2 and the
user must enter a date, the second blank, cell C2 contains =A2+6 to display
the end of the week date.
I then have 7 columns, one for each day of the week. Monday thru Sunday. I
am trying to get the date to display below each day of the week based on the
entry in cell A2. So I have entered in the cell below Monday, =a2; below
Tuesday, =a2+1; etc. It works fine with a date in cell A2. However, if the
contents of cell A2 are blank (deleted), the cells below Monday displays as
1/0, Tuesday as 1/1, etc. I would like blank or empty cells displayed for
the dates if the contents in cell A2 is deleted or blank.
Any help is appreciated.
Bill