| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I count the working day
How can I count the working day between two date,exlude saturday sunday and
30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
Try this out, worked for my little test
=WORKDAY(B1,0)-WORKDAY(A1,0) -- -John Please rate when your question is answered to help us and others know what is helpful. "onur" wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
Cancel that, it did days not work days....I'll be back!
-- -John Please rate when your question is answered to help us and others know what is helpful. "onur" wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
I want to count like that
A B C 12/07/07 15/08/07 total working days(exlude sat. sun. and 30/08/07) 15/07/07 04/09/07 total working days(exclude sat. sun. and 30/08/07) "John Bundy" wrote: Cancel that, it did days not work days....I'll be back! -- -John Please rate when your question is answered to help us and others know what is helpful. "onur" wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
Look at NETWORKDAYS function (Excel HELP)
"onur" wrote: I want to count like that A B C 12/07/07 15/08/07 total working days(exlude sat. sun. and 30/08/07) 15/07/07 04/09/07 total working days(exclude sat. sun. and 30/08/07) "John Bundy" wrote: Cancel that, it did days not work days....I'll be back! -- -John Please rate when your question is answered to help us and others know what is helpful. "onur" wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
I tried but I havent find a solution as I want.
In my opinion It will be solute with a function but I havent find it. "Toppers" wrote: Look at NETWORKDAYS function (Excel HELP) "onur" wrote: I want to count like that A B C 12/07/07 15/08/07 total working days(exlude sat. sun. and 30/08/07) 15/07/07 04/09/07 total working days(exclude sat. sun. and 30/08/07) "John Bundy" wrote: Cancel that, it did days not work days....I'll be back! -- -John Please rate when your question is answered to help us and others know what is helpful. "onur" wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
On Wed, 8 Aug 2007 05:36:02 -0700, onur wrote:
How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you Use the NETWORKDAYS function. List 30.08.2007 as a Holiday. e.g. A1: 12 Jul 2007 B1: 15 Aug 2007 I1: 30 Aug 2007 =NETWORKDAYS(A1,B1,$I$1) -- 25 --ron |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
I'm an 2002 user
but this function does not work in my excel after using excel gives me function error And I want to determine that ; I tried your given function also before and after you advice me thank you "Ron Rosenfeld" wrote: On Wed, 8 Aug 2007 05:36:02 -0700, onur wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you Use the NETWORKDAYS function. List 30.08.2007 as a Holiday. e.g. A1: 12 Jul 2007 B1: 15 Aug 2007 I1: 30 Aug 2007 =NETWORKDAYS(A1,B1,$I$1) -- 25 --ron |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
What error message did you get? Did you look at what Excel help tells you
about the NETWORKDAYS function? -- David Biddulph "onur" wrote in message ... I'm an 2002 user but this function does not work in my excel after using excel gives me function error And I want to determine that ; I tried your given function also before and after you advice me thank you "Ron Rosenfeld" wrote: On Wed, 8 Aug 2007 05:36:02 -0700, onur wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you Use the NETWORKDAYS function. List 30.08.2007 as a Holiday. e.g. A1: 12 Jul 2007 B1: 15 Aug 2007 I1: 30 Aug 2007 =NETWORKDAYS(A1,B1,$I$1) -- 25 --ron |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
"the formula you typed containss an error"
"David Biddulph" wrote: What error message did you get? Did you look at what Excel help tells you about the NETWORKDAYS function? -- David Biddulph "onur" wrote in message ... I'm an 2002 user but this function does not work in my excel after using excel gives me function error And I want to determine that ; I tried your given function also before and after you advice me thank you "Ron Rosenfeld" wrote: On Wed, 8 Aug 2007 05:36:02 -0700, onur wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you Use the NETWORKDAYS function. List 30.08.2007 as a Holiday. e.g. A1: 12 Jul 2007 B1: 15 Aug 2007 I1: 30 Aug 2007 =NETWORKDAYS(A1,B1,$I$1) -- 25 --ron |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
So what was the formula that gave that error? Copy from the formula bar to
here. -- David Biddulph "onur" wrote in message ... "the formula you typed containss an error" "David Biddulph" wrote: What error message did you get? Did you look at what Excel help tells you about the NETWORKDAYS function? "onur" wrote in message ... I'm an 2002 user but this function does not work in my excel after using excel gives me function error And I want to determine that ; I tried your given function also before and after you advice me "Ron Rosenfeld" wrote: On Wed, 8 Aug 2007 05:36:02 -0700, onur wrote: How can I count the working day between two date,exlude saturday sunday and 30.08.2007. The notice is there may be too many dates in two date coloumn and at some rows 2nd. dates may not pass 30.08.2007 help me thank you Use the NETWORKDAYS function. List 30.08.2007 as a Holiday. e.g. A1: 12 Jul 2007 B1: 15 Aug 2007 I1: 30 Aug 2007 =NETWORKDAYS(A1,B1,$I$1) -- 25 --ron |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I count the working day
On Thu, 9 Aug 2007 07:06:05 -0700, onur wrote:
I'm an 2002 user but this function does not work in my excel after using excel gives me function error And I want to determine that ; I tried your given function also before and after you advice me thank you The function works properly in XL2002. What is the exact formula you used? What was the text of the error message? If you used cell references in your formula, what is the contents of the cells to which you referred? --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count function not working, keeps displaying 0 | Excel Worksheet Functions | |||
| count not working in pivot table | Excel Worksheet Functions | |||
| Count is not working | New Users to Excel | |||
| Subtotal count not working | Excel Discussion (Misc queries) | |||
| how do i count how many people are working between two times in e | Excel Worksheet Functions | |||
Linear Mode
