I need to write a formula to calculate the number of week days in a year less
the holidays. Do I have to go through a calendar and count the holidays, or
does Excel have this built in somewhere?
--
JR

Thanks...this will make my project a lot easier! Appreciate the info.
--
JR


"daddylonglegs" wrote:


No, Excel doesn't have inbuilt holidays due to the differences country
to country.

You can use

=NETWORKDAYS(date(2006,1,1),date(2006,12,31))

to count the number of weekdays in 2006 or create a list of holidays
and use

=NETWORKDAYS(date(2006,1,1),date(2006,12,31),holid ays)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527355

using =datedif(a1,b1,"d") how can we eliminate the error msg if b1 empty or 0
or 01/01/1099 copy formula down works ok but have error msg in next cell
first time trying to use dated.
appreciate this forum. Thanks

"daddylonglegs" wrote:


No, Excel doesn't have inbuilt holidays due to the differences country
to country.

You can use

=NETWORKDAYS(date(2006,1,1),date(2006,12,31))

to count the number of weekdays in 2006 or create a list of holidays
and use

=NETWORKDAYS(date(2006,1,1),date(2006,12,31),holid ays)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527355

Hi Curt,

If you want the difference in days between two dates you can use just

=B1-A1

format as general

although to eliminate errors possibly

=IF(A1*B1,IF(A1<B1,B1-A1,""),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527355

Thank you for reply. I did make it function by entering zeros in blank cell.
This gave a date function. Will keep your formula for future reference thanks
again


"daddylonglegs" wrote:


Hi Curt,

If you want the difference in days between two dates you can use just

=B1-A1

format as general

although to eliminate errors possibly

=IF(A1*B1,IF(A1<B1,B1-A1,""),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527355