| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format text 'dates' to real dates | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
| Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Linear Mode
