Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone teach me how to use formula in Excel 2007 to find out the starting (beginning from Monday) and ending (ending on Saturday) dates based on week number? eg. week 32 of 2012 is from 06th August 2012 to 11th August 2012.

share|improve this question



where the 5 in the above formula is the week number

So, in CELL A1, type


and in CELL A2 type


You can also use cell references in the DATE() function which may help.

Just for completeness, you can get the week number by:



This seems even quicker:

From date:


To date:


share|improve this answer
Thank you guys, it has been a great help. – Chris Aug 8 '12 at 0:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .