P
Pat
I'm trying to develop a worksheet that calculates
available school days and school days missed while a
student is hospitalized.
I've set up the spreadsheet with the date in one column
and in another column a value of "1" for a school day
and "0" if it is a weekend or a holiday. I've been trying
to use a formula like the one below that calculates 30
days prior to the admission date and then compares that
calculated date to the date column of the spreadsheet.
Then it adds the values of "1" and "0" for the 30 day
period correlating to the calculated date. (sample
formula: =IF(I9=B1,SUM(C1:C30),IF(I9=B2,SUM(C2:C31)))
The problem is I'd have to repeat this for each date in
the calendar for the year. There has to be an easier way
to do this! I'm out of practice and need help!!
Thanks!!!
available school days and school days missed while a
student is hospitalized.
I've set up the spreadsheet with the date in one column
and in another column a value of "1" for a school day
and "0" if it is a weekend or a holiday. I've been trying
to use a formula like the one below that calculates 30
days prior to the admission date and then compares that
calculated date to the date column of the spreadsheet.
Then it adds the values of "1" and "0" for the 30 day
period correlating to the calculated date. (sample
formula: =IF(I9=B1,SUM(C1:C30),IF(I9=B2,SUM(C2:C31)))
The problem is I'd have to repeat this for each date in
the calendar for the year. There has to be an easier way
to do this! I'm out of practice and need help!!
Thanks!!!