Convert Week number to Month

K

KT

I have a worksheet with year and week number and want to use a funtion to
convert these two values into the descriptive month. Some weeks cross
months, but that's okay, I just need one value returned per record. It could
be the month that the first day of each week falls in. I'm using Excel 2003.

Thanks!
 

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 Week number into Month 5
Convert Month, Week, Year to date 2
Assign each week number to corresponding month of the year 5
Month value 3
Summing weekly values to fall into correct month 2
calculate month from week number 2
Can someone test this IF function for me, I'm not sure that it works. 3
Convert week number into calendar month? 2

Top