thanks to both of your golden heart Sir Ron and Sir Biff,

I'll place the 2 answers to my boss in my safebasket, it seems the right
formula is not yet traced from where it comes from..
Otherwise, I will count one-by-one with the calendar...Sirs, do you know a
link to find a calendar where the total number of sundays thru saturdays are
accounted in a yearly basis...I hope i dont need to start counting hair
losses and the colors and the sundays.

more power and happy holidays, with no heart feelings for 2007
romelsb




"T. Valko" wrote:

One way:

A1 = start date
A2 = end date

=SUM(INT((WEEKDAY(A1-n,2)+A2-A1)/7))

Where n = day of week: Monday = 1 through Sunday = 7

Biff

"dribler2" wrote in message
...
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.