L
lalani
I'm trying to make a time entry sheet. Each employee has their own sheet
and it carries a running total for the month. I've got the days of the
month running horizontally across the header row. The problem is, right
now I've set the number of colums at 31 days. So that for feb, the last
three colums become march 1,2,3. Is there a way to have it stop on the
last day of the month?
To clarify, in B4 I enter 2/1/04. Currently B5 is B4+1, B6 is B5+1 and
so on.
I don't mind using conditional formatting or any other way to simply
hide the end columns for months with less than 31 days.
and it carries a running total for the month. I've got the days of the
month running horizontally across the header row. The problem is, right
now I've set the number of colums at 31 days. So that for feb, the last
three colums become march 1,2,3. Is there a way to have it stop on the
last day of the month?
To clarify, in B4 I enter 2/1/04. Currently B5 is B4+1, B6 is B5+1 and
so on.
I don't mind using conditional formatting or any other way to simply
hide the end columns for months with less than 31 days.