Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Calculating total number of days in rolling year

0 views
Skip to first unread message

Suede

unread,
Nov 30, 2009, 7:58:01 PM11/30/09
to
I'm a novice to Excel and using Excel 2002 ver. I need to keep track of
employee absences for my company in a "rolling" 12 month period. e.g. if an
individual is permitted "x" days off/year and absent from work more or less
than the allocation -what would the formula be to determine an available
total on any day of the year.
Thanks.

Fred Smith

unread,
Nov 30, 2009, 9:46:20 PM11/30/09
to
It depends on what your data looks like. Tell us about your data structure.

Regards,
Fred.

"Suede" <Su...@discussions.microsoft.com> wrote in message
news:55720EBC-C070-43B5...@microsoft.com...

0 new messages