calculate month from week number

A

ankman

I need to be able to calculate the month from a week number entered ont
a worksheet. i.e.

week Month
1 Jan
2 Jan
3 Jan
4 Jan
5 Feb

A sumif statement will then be used to extract data from anothe
worksheet based on Month returned. (The months on the other workshee
are in text format)

Can anyone help? I'm stumped!

Thanks Guy
 
B

bveara

This works too. Cell A14 has the week number. Cell B14 has the year.
Returns the date of the Monday of that week.

=DATE(B14,1,1)+((A14-1)*7)-WEEKDAY(DATE(B14,1,1)+(A14-1)*7,2)+1

-BV
 

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

calculating number of days belonging to each month within a given week 2
Assign each week number to corresponding month of the year 5
Function Problem 6
Specify a column by the month to calculate it's data 6
specify which month's columns to use in mtd calculation 0
How can count the number of cells that fulfill certain criteria in other cells 2
Specify MTD Diff by month's columns 0
Specify columns to add for months MTD Diff 3

Top