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.
|