How can we get the date of the Monday of Week 44 of Year 2005 using Excel function/s ?
D datt350 Jun 9, 2005 #1 How can we get the date of the Monday of Week 44 of Year 2005 using Excel function/s ?
D Domenic Jun 9, 2005 #2 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!
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!
