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

  • Thread starter Thread starter datt350
  • Start date Start date
D

datt350

How can we get the date of the Monday of Week 44 of Year 2005 using
Excel function/s ?
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Month, Week, Year to date 2
Bi-weekly date dilema 8
Given today's date, I want this week's Monday's date 3
Finding the Monday date based on a different date in same week 4
Inverse to WEEKNUM 8
Determine year over year date for comparison 3
Calculate number of Mondays betweeb 2 dates 6
How do I get the week in month from a date? 2

Back
Top