Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Two solutions found online, two problems.
1) =NETWORKDAYS function should do the job, but I keep winding up with a #NAME? error. (Using Excel 2003) 2) Formula suggestion, where A2 contains the earlier date and B2 contains the later date: =MAX(WEEKDAY(B2,2)-WEEKDAY(A2,2),0)+1+INT((B2-A2)/7)*5 gets hosed when one or both days are Saturday or Sunday http://www.ozgrid.com/forum/showthread.php?t=65032 An explanation for 1), modification of 2) or other suggestion is appreciated. TIA. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round dates to weekdays | Excel Worksheet Functions | |||
Difference (weekdays) between two dates | Excel Worksheet Functions | |||
dates for weekdays in non-contiguous cells | Excel Worksheet Functions | |||
How do i count number of weekdays between two dates? | Excel Worksheet Functions | |||
Fill dates with weekdays/workdays only | Excel Worksheet Functions |