calculate days

[JR]

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

[daddylonglegs]

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),holidays)

[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),holidays)
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=527355
>
>

[Curt]

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
[email protected]
"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),holidays)
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=527355
>
>

[daddylonglegs]

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,""),"")

[Curt]

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
[email protected]

"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
>
>