We track our 'days off' for all employees in our office with a Group Calendar
in Outlook.
I've created a 'view' so that I can filter on each person in my office and
see the number of vacation days vs sick vs 'out'. However, I noticed that
although someone has actually taken off 3 days, it only shows 1 in the
duration column. It has something to do with the fact that if a vacation
falls across a weekend, we put it in as a Recurrence: Occurs every weekday
effective ##/##/## until ##/##/##. Technically this is still 3 days, but the
duration only shows 1 day.

However, we can't put in 3 days in the recurrence/duration because we get
the error message: Duration cannot exceed the number of days...

So, based on that information, our spreadsheet may be incorrect now. Do you
know any way to get this to calculate correctly, using the actual number of
days 'out'?