Ive created a calender on a worksheet, in another worksheet dates are put in
manually with the days the workers have for there holidays persides the
dates. The dates in A row represent the start date. Row B represents the end
date of the holiday. Row C represnet the number of days off.

A1=14/02/06 B1=15/02/06 C1=2

Is there any way to link the days off in C1 with a calender in another
worksheet automatically?