Weekends

V

Voodoodan

Hello!

Between two given dates, is there any way of working out the total
amount of days that fall on a Saturday and Sunday?

For example, C1 would indicate the total number of weekend days falling
between the following dates:

A1 = 10/11/2003
B1 = 17/11/2003
C1 = 2

Any help would be appreciated.

Thanks,
Dan.
 
A

Arvi Laanemets

Hi

=(EndDate-StartDate) -NETWORKDAYS(StartDate,EndDate)
or
=(EndDate-StartDate) -NETWORKDAYS(StartDate,EndDate,Holydays)
(the last one gives you weekends+holydays)
You must have Analysis Toolpack installed
 
V

Voodoodan

Hi Jason,

I've tried that but it doesn't seem to work. It keeps coming back a
me with '#NAME?'.

Thanks,
Dan
 
L

Lovelock, David

Couldn't you also calculate the difference in the dates 10/11/2003 -
17/11/2003 and multiply by 2/7? Also use 5/7 to calculate workdays, or
4/7 if your on 4 day weeks? I used to do this within Crystal Reports to
get the same results.
 
Top