whichever Mondays has in a certain month?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M. Caricola - 02 Nov 2006 15:42 GMT

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

Reply to this Message

Niek Otten - 02 Nov 2006 15:54 GMT

Hi Mario,

Look here:

http://www.cpearson.com/excel/DateTimeWS.htm#LastWeekday

Look for: Number of Mondays in Periods

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello, my english is bad, but i try...
| whichever Mondays has in a certain month?
[quoted text clipped - 5 lines]
|
| Mario

Reply to this Message

M. Caricola - 02 Nov 2006 16:02 GMT

Thanx

> Hi Mario,
>
[quoted text clipped - 13 lines]
> |
> | Mario

Reply to this Message

Bob Phillips - 02 Nov 2006 16:12 GMT

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.

Signature

HTH

Bob Phillips

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

> Hello, my english is bad, but i try...
> whichever Mondays has in a certain month?
[quoted text clipped - 5 lines]
>
> Mario

Reply to this Message