Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Business Day
In column A = Pick Up Date In column B = Return Date Column C = calculate if column the businessday. If days are 5 days or under, blank. If more than 5 days, indicate the how many days starting on the 6 day. -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=517018 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Business Day
=IF(NETWORKDAYS(A2,B2,G1:G10)5,NETWORKDAYS(A2,B2, G1:G10),"") Where G1:G10 are your holidays. If no holidays then omit the G1:G10 from the NETWORKDAYS functions. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=517018 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Business Day
Dannyboy
How about =IF(NETWORKDAYS(A2,B2)<6,"",NETWORKDAYS(A2,B2)) You will need to load the analysis toolpak (ToolsAdd-ins...) to get the networkdays function. This works with weekends, you will need to use the last 'holidays' optional parameter to do other than this -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "dannyboy213" wrote in message ... In column A = Pick Up Date In column B = Return Date Column C = calculate if column the businessday. If days are 5 days or under, blank. If more than 5 days, indicate the how many days starting on the 6 day. -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=517018 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Business Day
I want the formula to start counting on the 6th day. So it the total days is 6 day, I want it to show "1". on the 7th as "2" as so on. -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=517018 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Business Day
dannyboy,
Not sure if your question has to do with "Business Day(s)" (Mon-Fri) or not. If so, see the earlier two posts. If you don't care about business days, how about: =If((b1-a1)<6,"",(b1-a1)-5) HTH "dannyboy213" wrote: In column A = Pick Up Date In column B = Return Date Column C = calculate if column the businessday. If days are 5 days or under, blank. If more than 5 days, indicate the how many days starting on the 6 day. -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=517018 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many business days were in 2005? | Excel Worksheet Functions | |||
With this business with ONLY 5,- EUR OVER 61,370 EUR in 3 months earn!! | Charts and Charting in Excel | |||
With this business with ONLY 5,- EUR OVER 61,370 EUR in 3 months earn!! | Charts and Charting in Excel | |||
Where can I find a 2006 Business Calendar template? | Charts and Charting in Excel | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) |