| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Complex Date Functions
Hi, I have two dates (E8 = 17/02/05 & E9 =26/02/05).
I want to know how many days in that range are Fridays, Saturdays or Sundays as I am building a work schedule to calcuate days not worked and men only work Mon to Thursday. I need to use standard excel functions as the workbook must be compatiable on all computer (even without toolpak installed). Any idea would be appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date and time | New Users to Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| How do I create complex functions? | Excel Worksheet Functions | |||
Threaded Mode
