3rd Sunday of Month

[pennynikkel]

What type of formula can I use to have excel calculate the 3rd Sunday of each month?

Thank you.

 

[Patrick Alexander]

do you give the month and year?
or does excel have to give a range of dates

 

[Greg Truby]

May I suggest searching for keywords like "4th", "Monday" and "Month"? You should get several good hits.

 

[Andrew Poulsom]

Look here:

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

 

[pennynikkel]

Thank you for your assistance...I was able to find help on another link.