calculate days

J

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?
 
D

daddylonglegs

No, Excel doesn't have inbuilt holidays due to the differences countr
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 holiday
and use

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

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]
 
D

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

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]
 
Top