Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
I need a Formula that will count weekdays only For Example A1-7/13/06 I am going to need 12 days to complete the task so in another cell i want it to only count 12 working days (monday to friday) and display the result in cell c1 any help ? -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
Hi!
Try this: =WORKDAY(A1,12) The workday function requires the Analysis ToolPak add-in be installed. If the formula returns #NAME? that probably means you don't have the ATP installed. If that's the case, goto the menu ToolsAddins. Biff "Ziggy M" wrote in message ... I need a Formula that will count weekdays only For Example A1-7/13/06 I am going to need 12 days to complete the task so in another cell i want it to only count 12 working days (monday to friday) and display the result in cell c1 any help ? -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
The formula is
=WORKDAY(A1,12) but it can be expanded to include a list of holidays: check out Help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
Hi,
try NETWORKDAYS() function - just search help as not sure how it works. just have start/end date parameters I believe. god luck Ziggy M wrote: I need a Formula that will count weekdays only For Example A1-7/13/06 I am going to need 12 days to complete the task so in another cell i want it to only count 12 working days (monday to friday) and display the result in cell c1 any help ? -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
=workday(A1,12)
This is part of analysis toolpak (Tools=Add-ins=Analysis Toolpak) HTH "Ziggy M" wrote: I need a Formula that will count weekdays only For Example A1-7/13/06 I am going to need 12 days to complete the task so in another cell i want it to only count 12 working days (monday to friday) and display the result in cell c1 any help ? -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
P.S.
This formula returns the date serial number. You'll have to format the formula cell as DATE. Biff "Biff" wrote in message ... Hi! Try this: =WORKDAY(A1,12) The workday function requires the Analysis ToolPak add-in be installed. If the formula returns #NAME? that probably means you don't have the ATP installed. If that's the case, goto the menu ToolsAddins. Biff "Ziggy M" wrote in message ... I need a Formula that will count weekdays only For Example A1-7/13/06 I am going to need 12 days to complete the task so in another cell i want it to only count 12 working days (monday to friday) and display the result in cell c1 any help ? -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
Amazing Thank You :) -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
You're welcome!
Biff "Ziggy M" wrote in message ... Amazing Thank You :) -- Ziggy M ------------------------------------------------------------------------ Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
Just an after thought, but if you need to account for holidays, you can use NETWORKDAYS. This will allow you to create a list of holidays that will be skipped in addition to Saturday and Sunday. Please note that this also requires the analysis toolpak to be installed. -- mhart210 ------------------------------------------------------------------------ mhart210's Profile: http://www.excelforum.com/member.php...o&userid=26413 View this thread: http://www.excelforum.com/showthread...hreadid=561241 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Count Weekdays Formula
"mhart210" wrote in
message ... Just an after thought, but if you need to account for holidays, you can use NETWORKDAYS. This will allow you to create a list of holidays that will be skipped in addition to Saturday and Sunday. Please note that this also requires the analysis toolpak to be installed. The WORKDAY function also has an optional holidays argument. Syntax WORKDAY(start_date,days,holidays) Biff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003, which formula will count the cells that meet 2 conditi | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |