| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Other approach (without holidays, calculating from 24:00
of first date to 24:00 of second date): =(A2-WEEKDAY(A2,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY (A1,2))+MIN(5,WEEKDAY(A2,2)) HTH, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Threaded Mode
