| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to find nos. of each day in certain nos. of days?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find nos. of each day in certain nos. of days?
If you provide more information about your data, someone may be able to
provide advice. However, if you have a list of days, you could create a pivot table from the list, to get a count of each day. There are instructions and links he http://www.contextures.com/xlPivot01.html Khan wrote: -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find nos. of each day in certain nos. of days?
To count the number of Mondays between 2 dates (inclusive):
A1 = start date A2 = end date =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=2)) 2 = day of the week = Monday, whe Sunday = 1 through Saturday = 7 Biff "Khan" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to find a excel programme for rota's | Excel Discussion (Misc queries) | |||
| duration days | Excel Discussion (Misc queries) | |||
| CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz | Excel Discussion (Misc queries) | |||
| to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Hybrid Mode
