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.
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: