You're welcome! I missed a couple of days due to a bad modem. I'm here
every day barring technical difficulties!

Biff

"dribler2" wrote in message
...
Happy New Year Biff, Sir

Thanks for passing by. I thought you're on vacation.. I know u can help a
lot of novice like me. Specially this coming New Year 2007.

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