Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

Yes:

=DATE(2012,1,5*7-2)-WEEKDAY(DATE(2012,1,3))

where the 5 in the above formula is the week number

So, in CELL A1, type

=DATE(2012,1,1*7-2)-WEEKDAY(DATE(2012,1,3))

and in CELL A2 type

=DATE(2012,1,1*7+3)-WEEKDAY(DATE(2012,1,3))

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

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

=WEEKNUM(DATE(2012,8,1))

EDIT

This seems even quicker:

From date:

=DATE(2012,1,32*7-5)

To date:

=DATE(2012,1,32*7)

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.