For the week beginning on Sunday...

=TEXT(A1,"dddd")&" of Week "&WEEKNUM(A1)&" of Year "&YEAR(A1)

For the week beginning on Monday...

=TEXT(A1,"dddd")&" of Week "&WEEKNUM(A1,2)&" of Year "&YEAR(A1)

Hope this helps!

In article .com,
"datt350" wrote:

How can we get the date of the Monday of Week 44 of Year 2005 using
Excel function/s ?