Hello,

I have a question for the gurus here.
I am working on a spreadsheet where in column A I have Total # of Vacation
days.
Example:
# Vac Days --- # Weekdays --- # Weekend days
75 55 20
44 32 12
25 19 6
I figured this out by simply creating a list like this
1 Weekday
2 Weekday
3 Weekday
4 Weekday
5 Weekday
6 Weekend
7 Weekend
And so on...
And then doing a countif to figure out how many of either on a given range.
Setting up this list is not practical since I'd have to adjust each formula
to only take the correct range into account when counting the days, and doing
this on a spreadsheet with hundreds of rows of data would take too long.
So I'd like to know if there is a way that this could be figured out
withouth the COUNTIF. Assuming that day 1 is always Monday is OK. And no
need to account for Hollidays.

Thanks
Juan Correa