Working days between dates

M

Michael

Hi,

I have a problem when I try to calculate number of working days between to dates. When I have the samt dates it sometimes returns 0 days and sometimes 1 days

I would like it to show 1 day when date1 and date2 are the same. Can somebody help me out

Thanks in advanc

Michael
 
F

Frank Kabel

Hi
use NETWORKDAYS. e.g.
=NETWORKDAYS(A1,B1)
-----Original Message-----
Hi,

I have a problem when I try to calculate number of
Click to expand...
working days between to dates. When I have the samt dates
it sometimes returns 0 days and sometimes 1 days.
I would like it to show 1 day when date1 and date2 are
Click to expand...
the same. Can somebody help me out.
 
R

Ron Rosenfeld

Hi,

I have a problem when I try to calculate number of working days between to dates. When I have the samt dates it sometimes returns 0 days and sometimes 1 days.

I would like it to show 1 day when date1 and date2 are the same. Can somebody help me out.

Thanks in advance

Michael
Click to expand...

What formula are you using to perform the calculation?

If you are using NETWORKDAYS, and the date is on a weekend, you will get a
zero.


--ron
 
M

Michael

Hi, I use NETWORKDAYS. I have two examples: The first returns 1 day and the secund returns 0 days. There is not any holiday dates. What I would like is to have the return min 1 da

1. =NETWORKDAYS(A13;B13) where A13 is 2004-03-19 and A14 2004-03-19. This return 1 da
2. =NETWORKDAYS(A14;B14) where A14 is 2004-03-20 and B14 2004-03-20. This return 0 day

I would really appreciate all help that I can ge

Regards

Michael
 
R

Ron Rosenfeld

Hi, I use NETWORKDAYS. I have two examples: The first returns 1 day and the secund returns 0 days. There is not any holiday dates. What I would like is to have the return min 1 day

1. =NETWORKDAYS(A13;B13) where A13 is 2004-03-19 and A14 2004-03-19. This return 1 day
2. =NETWORKDAYS(A14;B14) where A14 is 2004-03-20 and B14 2004-03-20. This return 0 days

I would really appreciate all help that I can get

Regards,

Michael
Click to expand...

As I implied, NETWORKDAYS does NOT count weekend days. It excludes Saturdays,
Sundays and (optionally) holidays.

Your first example is a Friday and NETWORKDAYS, as designed, returns a 1.
Your second example is a Saturday and NETWORKDAYS, as designed, returns a 0.

Perhaps you had best tell us exactly what you are trying to do. If you are
going to count Saturday as a workday, then NETWORKDAYS may not be an
appropriate function to use. If you are using a different algorithm, you will
have to let us know what it is.


--ron
 
Top