How do I convert a calendar week into a date in Excel?

excel date excel-formula
Ber picture Ber · Jun 12, 2012 · Viewed 135.7k times · Source

I have a week number and a year, and would like to calculate the date of the Monday for that specific week in Microsoft Excel.

Year   Week   Date (Monday)
2012   1      January 2, 2012
2013   16     April 15, 2013
2014   42     October 13, 2014

What formula can I use to convert a calendar week to a specific date?

Answer

barry houdini picture barry houdini · Jun 12, 2012

For ISO week numbers you can use this formula to get the Monday

=DATE(A2,1,-2)-WEEKDAY(DATE(A2,1,3))+B2*7

assuming year in A2 and week number in B2

it's the same as my answer here https://stackoverflow.com/a/10855872/1124287

Related questions

SUMIFS with date and name criteria... month and year only

I am trying to get a SUMIFS formula to check a column of dates and sum only the values that correspond to the matching year and month of the criterion date. I would also like this SUMIFS to include a …

Read More
Sumif between two dates over two columns

I would like to sum a column between two dates, however the dates are in separate columns. I want the sum total between the following dates 01-01-2014 (cell E1) and 31-03-2014 (cell F1). If you look at cell …

Read More
Count number of times a date occurs and make a graph out of it

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number …

Read More