Calculate holidays between two dates

[mrdzyyyrawr]

Hi,

I use the following formula to calculate how many days off an employee has over a month. Where J Column is a drop down option with DAY OFF, HALF DAY etc & B Column is how much each day is worth. For example a saturday is worth 0.5 and a weekday is worth 1.

=SUMIF(J192:J218,"Day Off",B192:B218)+SUMIF(J192:J218,"Half Day",B192:B218)/2+SUMIF(J192:J218,"Other Duties",B192:B218)

I need this exact formula but to only calculate between 2 dates.

Any help would be greatly appreciated.

Thank.

 

[Chrisdontm]

In order to alter the formula to look at dates also, you would need a column of dates to reference within the formula.
Do you happen to have a column of the dates...?

Then you would also like a couple of cells to put the beginning date and ending date. ( Usually located near the top of the page near your output cell where the formula will go...)