| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting dates but excluding weekends
Is there a function to count the difference of days, but to exclude the
weekend? For example, Cell A2 has the date Monday, August 11, 2008 and cell A4 has the date Tuesday, August 19, 2008 What would the function be to count the number of days in between? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting dates but excluding weekends
Check out help on the WORKDAYS function.
Note that the Analysis Toolpak add-in must be loaded. Gord Dibben MS Excel MVP On Mon, 11 Aug 2008 17:04:06 -0700, Sara wrote: Is there a function to count the difference of days, but to exclude the weekend? For example, Cell A2 has the date Monday, August 11, 2008 and cell A4 has the date Tuesday, August 19, 2008 What would the function be to count the number of days in between? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting dates but excluding weekends
Hi Sara
Try: =NETWORKDAYS(A2,A4) Regards, Pedro J. Is there a function to count the difference of days, but to exclude the weekend? For example, Cell A2 has the date Monday, August 11, 2008 and cell A4 has the date Tuesday, August 19, 2008 What would the function be to count the number of days in between? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting dates but excluding weekends
Hi Sara
If you are not able to use the Analysis Toolpak function Workdays, as already suggested, then you could use =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&A4)))<6)) -- Regards Roger Govier "Sara" wrote in message ... Is there a function to count the difference of days, but to exclude the weekend? For example, Cell A2 has the date Monday, August 11, 2008 and cell A4 has the date Tuesday, August 19, 2008 What would the function be to count the number of days in between? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to write Calendar dates excluding weekends - urgent pleas | Excel Discussion (Misc queries) | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Subtact 2 dates to get the number without counting weekends? | Excel Worksheet Functions | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| How to Calculate Dates without counting the weekends | Excel Worksheet Functions | |||
Linear Mode
