ExcelBanter - Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005? (https://www.excelbanter.com/excel-worksheet-functions/29923-microsoft-excel-how-can-we-get-date-monday-week-44-year-2005-a.html)

datt350

Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005?

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

Domenic

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 ?

All times are GMT +1. The time now is 01:17 AM.