How to tell first mon, tue,wed etc

[peterwillmo]

I have an MS Excel (Version 2003 sp3) spreadsheet with approx 1500 rows of data all with date and day entered. I need to add an entry showing wether a particular date is the first, second, third, fourth or fifth monday, tuesday, wednesday, thursday, friday, saturday or sunday of that month. Would appreciate help on this.
Thank you
Peter

 

[Jonmo1]

Welcome to the board

Try

=ROUNDUP(DAY(A1)/7,0) & TEXT(A1," dddd")

 

[Gerald Higgins]

With a date in A1, this formula will return a result such as "3 Tuesday" for Tuesday 15th March 2011.

=ROUNDUP((A1-DATE(YEAR(A1),MONTH(A1),1)+1)/7,0)&" "&TEXT(A1,"DDDD")

Edit to add - Jonmo1's solution is similar but neater than mine.

 

[peterwillmo]

Great!! Many thanks for your help, it works perfectly.
Peter