S
Satya
I am writing a shift roster for 24 x 7 support. I do my
time calculations based on days of month. I achieve this
by filling up cells with all days of a month using formula
=IF(AC8="","",IF(MONTH(AC8+1)<>MONTH($B$4),"",AC8+1))
where cell B4 is a drop down list of months. To obtain the
number of the day, I use
=WEEKDAY(AC7,2) where 2 is for Mon=1 to Sun=7.
I am using SUMPRODUCT to calculate shifts, holidays etc.
Problem is I use the max range of days in a month (ie 31
cells) to calculate. Its ok if month has 31 days. But I
get #VALUE error for shorter months because the date cell
returns a blank and the day cell returns error.
How can I overcome this? Aprec yr expert help
time calculations based on days of month. I achieve this
by filling up cells with all days of a month using formula
=IF(AC8="","",IF(MONTH(AC8+1)<>MONTH($B$4),"",AC8+1))
where cell B4 is a drop down list of months. To obtain the
number of the day, I use
=WEEKDAY(AC7,2) where 2 is for Mon=1 to Sun=7.
I am using SUMPRODUCT to calculate shifts, holidays etc.
Problem is I use the max range of days in a month (ie 31
cells) to calculate. Its ok if month has 31 days. But I
get #VALUE error for shorter months because the date cell
returns a blank and the day cell returns error.
How can I overcome this? Aprec yr expert help