Working with Dates
 

How do I calculate the number of business days between two dates? For
example: between 12/01/2006 and 12/27/2006 I need a formula that calculates
how many business days (Monday thru Friday) there are.

Working with Dates
 

See Help for NETWORKDAYS
happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Byron720" wrote in message
...
How do I calculate the number of business days between two dates? For
example: between 12/01/2006 and 12/27/2006 I need a formula that
calculates
how many business days (Monday thru Friday) there are.

Working with Dates
 

Thanks. It worked. Is there a way to do the same but with hours this time?
For example: a project started at 4:00 PM and ended next day at 10:00 AM
(business hours are from 8 to 5)

"Bernard Liengme" wrote:

See Help for NETWORKDAYS
happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Byron720" wrote in message
...
How do I calculate the number of business days between two dates? For
example: between 12/01/2006 and 12/27/2006 I need a formula that
calculates
how many business days (Monday thru Friday) there are.

Working with Dates
 

If you want the result in hours (for your example the result would be 3:00)
try this

=(NETWORKDAYS(A1,B1)-1)*("17:00"-"08:00")+MOD(B1,1)-MOD(A1,1)

format result cell as [h]:mm

where A1 contains your start time/date and B1 end time/date

Note: both A1 and B1 should be within business hours

"Byron720" wrote:

Thanks. It worked. Is there a way to do the same but with hours this time?
For example: a project started at 4:00 PM and ended next day at 10:00 AM
(business hours are from 8 to 5)

"Bernard Liengme" wrote:

See Help for NETWORKDAYS
happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Byron720" wrote in message
...
How do I calculate the number of business days between two dates? For
example: between 12/01/2006 and 12/27/2006 I need a formula that
calculates
how many business days (Monday thru Friday) there are.