| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of Weekend Days between 2 Dates Q
Is it possible to calculate the number of weekend days between two
dates? Below is my formula that returns the number of days between 2 inputted values, but what is the total weekend days between these two values? ((Masters!I52-(Masters!I1-6)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of Weekend Days between 2 Dates Q
The NETWORKDAYS function gives you the number of non-weekend days between two
given dates, so you could just subtract this result from your formula result. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Seanie" wrote: Is it possible to calculate the number of weekend days between two dates? Below is my formula that returns the number of days between 2 inputted values, but what is the total weekend days between these two values? ((Masters!I52-(Masters!I1-6)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
| changing weekend days | Setting up and Configuration of Excel | |||
| add days without adding weekend | New Users to Excel | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Weekend days other than Sat Sun | Excel Worksheet Functions | |||
Linear Mode
