Non-VBA formula to find 2nd Sunday of a given month

[Bob Phillips]

David,

You asked this question on 27th Nov 2003, and this is the answer I gave
then.

Assuming you have a date in A1, this gives the 2nd Sunday of that date

DATE(YEAR(A1),MONTH(A1),1)+MOD(8-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),7)+7

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Totally gone. This is the post from then - no wonder it looked familiar.

 

[Mike A]

I hate when that happens...

<vbg>

BTW, if you post an empty message with the subject line

cancel "The exact subject line of your message"

the news server will delete your post, and this will propagate to the
other servers. Google may archive your faux pas in the meantime, but
you gotta leave your mark somehow!

I use this cancel thing more often than I'd care to count!!

-Mike

Totally gone. This is the post from then - no wonder it looked familiar.

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers