How many business days were in 2005?

T

TC

I need to know how many business days were in 2005 for purposes of dividing
an employee benefit plan by the number of business days in the calendar
fiscal year.
 
B

Bob Phillips

Surely it is just 52*5 + 1 if it was a leap year.

If you want to exclude public holidays, just subtract that number.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

Chip Pearson

Try the following formula:

=NETWORKDAYS(DATE(2005,1,1),DATE(2005,12,31))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
C

CLR

It depends.........NETWORKDAYS considers weekends as non-workdays.....they
may not be such in your business.........scheduled plant closings would have
to also be entered as "holidays", etc etc........probably best to just mark a
calendar and count them.

Vaya con Dios,
Chuck, CABGx3
 
R

Ron Rosenfeld

I need to know how many business days were in 2005 for purposes of dividing
an employee benefit plan by the number of business days in the calendar
fiscal year.
Click to expand...


Are your business days Monday-Friday excluding Holidays?

If so, you'll need to set up a range with the holiday dates for 2005.

Then use the function:

=NETWORKDAYS(DATE(2005,1,1),DATE(2005,12,31), Holidays)


--ron
 
S

sandved

If you use my Generic Excel Calendar at

http://www.ProbabilityOf.com/excel.shtml



You can use the UDF: =DateToWeek(A1), =NorskHelligdagSant(A1;1;1) and
=NorskHelligdagdesc(A1;1;1) in the sheet Excel_Calendar.xls. It may be
wise to adjust the text and non working days to your country (should be
self explaining if you can UDF)

Make a list with all the dates (SANN = TRUE, USANN = FALSE) like:

Date ISOWeek
=DateToWeek(A1) =NorskHelligdagSant(A1;1;1) =NorskHelligdagdesc(A1;1;1)
2005-01-01 2004-W53-6 SANN 1. nyttårsdag
2005-01-02 2004-W53-7 SANN søndag
2005-01-03 2005-W01-1 USANN
2005-01-04 2005-W01-2 USANN
2005-01-05 2005-W01-3 USANN
2005-01-06 2005-W01-4 USANN
2005-01-07 2005-W01-5 USANN
2005-01-08 2005-W01-6 SANN lørdag
2005-01-09 2005-W01-7 SANN søndag
2005-01-10 2005-W02-1 USANN
2005-01-11 2005-W02-2 USANN

2005-03-12 2005-W10-6 SANN lørdag
2005-03-13 2005-W10-7 SANN søndag
2005-03-14 2005-W11-1 USANN
2005-03-15 2005-W11-2 USANN
2005-03-16 2005-W11-3 USANN
2005-03-17 2005-W11-4 USANN
2005-03-18 2005-W11-5 USANN
2005-03-19 2005-W11-6 SANN lørdag
2005-03-20 2005-W11-7 SANN søndag
2005-03-21 2005-W12-1 USANN
2005-03-22 2005-W12-2 USANN
2005-03-23 2005-W12-3 USANN
2005-03-24 2005-W12-4 SANN Skjærtorsdag
2005-03-25 2005-W12-5 SANN Langfredag
2005-03-26 2005-W12-6 SANN lørdag
2005-03-27 2005-W12-7 SANN 1. påskedag
2005-03-28 2005-W13-1 SANN 2. påskedag
2005-03-29 2005-W13-2 USANN
2005-03-30 2005-W13-3 USANN
2005-03-31 2005-W13-4 USANN
2005-04-01 2005-W13-5 USANN
2005-04-02 2005-W13-6 SANN lørdag
2005-04-03 2005-W13-7 SANN søndag
 
Top