whichever Mondays has in a certain month?

M

M. Caricola

Hello, my english is bad, but i try...
whichever Mondays has in a certain month?
example: November 2006 = 4 Mondays

use Excel 2003

Thanx

Mario
 
B

Bob Phillips

Instances In A Month

=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-wdn))

with date in A1, and where wdn is the week day number, 0 = Sun, 1 = Mon, 2 =
Tues, etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top