View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dribler2 dribler2 is offline
external usenet poster
 
Posts: 96
Default count weekday()=1

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.