Weekends

[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.

 

[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

 

[Jason Morin]

One way:

=B1-A1-NETWORKDAYS(A1,B1)

HTH
Jason
Atlanta, GA

 

[Voodoodan]

Hi Jason,

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

Thanks,
Dan

 

[brianwa]

You have to add this function in.

Go to Tools/Add Ina/Analysis ToolPak.

Good luck

 

[Voodoodan]

Thank you all, that works great.

Dan

 

[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.