Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week count
Hi,
Can any one tell me how can we calculate the Number of weeks between two dates. Also pls tell me separate function which calculates only the working days (Monday - Friday) and shud return the count of days. Ex : start date is 20/12/2007 and End date is 26/12/2007. Answer shud be 5 Days. Thanks in advance!!!!!!!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week count
hi
if your dates were in a1(20/12/07) and b1(26/12/07) then in c1 put.... =(b1-c1)/7 To calculate workdays... =networkdays(a1,b1) the networkdays function comes with the Analysis ToolPak, an addin that came with your install disk but does not install by default. if you get the #NAME? error, you will have to install the toolpak. then on the menu bar.... ToolsAddinscheck Analysis ToolPakok. Regards FSt1 "Christopher Naveen" wrote: Hi, Can any one tell me how can we calculate the Number of weeks between two dates. Also pls tell me separate function which calculates only the working days (Monday - Friday) and shud return the count of days. Ex : start date is 20/12/2007 and End date is 26/12/2007. Answer shud be 5 Days. Thanks in advance!!!!!!!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week count
Weeks
=INT((B2-B1)/7) Days =NETWORKDAYS(B11,B12) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Christopher Naveen" wrote in message ... Hi, Can any one tell me how can we calculate the Number of weeks between two dates. Also pls tell me separate function which calculates only the working days (Monday - Friday) and shud return the count of days. Ex : start date is 20/12/2007 and End date is 26/12/2007. Answer shud be 5 Days. Thanks in advance!!!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Week Of Month | Excel Worksheet Functions | |||
How t count by week whatever is with in the week (two criteria, ma | Excel Discussion (Misc queries) | |||
Count up each day of the week | Excel Worksheet Functions | |||
reverse week count calculations | Excel Worksheet Functions | |||
Help with week day count with range | Excel Worksheet Functions |