Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
pls give me a single formula to count the desired number of specific weekday.
something like this =countif(start_date:end_date,weekday(1)) e.g. if start_date is 01/Dec/06 and end_date is 31/Dec/06, then find how many sundays are within this 2 dates. (in this case the count = 5) I hope someone out there can share their bright formulated gifts this new year. .. wish it is easy... dribler2. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need formula to count spinoffs | Excel Worksheet Functions | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |