| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Determine weekday counts
I'm trying to show the number of days between two dates. The formula
below works, but counts EVERY day. I just want the weekdays counted (exclude Sat and Sun). Can you assist? =IF(AND(E20<"",G20<""),DAYS360(E20,G20),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Determine Frequency in Filtered List | Excel Worksheet Functions | |||
| determine which cell a value is returned from | Excel Discussion (Misc queries) | |||
| weekday display in excel | Excel Worksheet Functions | |||
| formula to determine the first column containing any data | Excel Worksheet Functions | |||
Threaded Mode
