Date format of just "st" "nd" "rd" and "th" with text included

Hi everyone.

This page has what I needed... The Date format ending with "st" "nd" "rd" and "th".

However, I was hoping there was a way to add "Week of" to the beginning of this date format with the year at the end?

Example of what I need for my dates (And would be so grateful if anyone could help):

"Week of August 1st, 2013"

Thank you for all your help

Well, amongst many possibilities, you could adapt daddylonglegs' solution, assuming your day is in A1 and year in B1:

="Week of "&TEXT(A1,"mmmm d")&LOOKUP(DAY(A1),{1,2,3,4,21,22,23,24,31;"st","nd","rd","th","st","nd","rd","th","st"})&", "&B1

Regards

With a date in A1:

="Week of " & TEXT(A1,"mmmm") & " " & DAY(A1) & MID("thstndrdth",MIN(9,2*RIGHT(DAY(A1))*(MOD(DAY(A1)-11,100)>2)+1),2) & " " & YEAR(A1)