Calculating how many Saturdays there are between two given dates
Try this:
With
A1: (the start date)
A2: (the end date)
This formula counts the number of a specific weekday within that range
=SUM(INT((WEEKDAY(A1-x)+A2-A1)/7))
Note: Replace "x" with one of these values: 1=Sun, 2=Mon.....7=Sat
To count Saturdays....use this:
=SUM(INT((WEEKDAY(A1-7)+A2-A1)/7))
Is that something you can work with?
***********
Regards,
Ron
XL2003, WinXP
" wrote:
As a Human Resources Manager, I need to calculate how many working
days leave each employee takes.
As some staff work a 5-day week I have used the formula,
=NETWORKDAYS(A1,B1,O1:O15) where A1 is the first day of leave and B1
is the last day of leave. O1 to O15 list public holidays which the
formula then deducts.
However I want to add a column for staff who work a six-day week with
a formula which will count the number of Saturdays in this same period
( adding the two results will give me how many working days 6-day-a-
week employees take)
Can any one please help?
|