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.

Take a look at NETWORKDAYS() in the help menu.

--
Regards,
Dave


"TC" wrote:

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.

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)

"TC" wrote in message
...
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.

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




"TC" wrote in message
...
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.

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



"TC" wrote:

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.

On Fri, 13 Jan 2006 10:09:02 -0800, "TC" wrote:

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.


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

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