Hi,
Is there any a simple way to convert week number to date range. For example, if I have the data=3, then I would like to convert it to 1/11/2009 to 1/17/2009.
Thanks!
Lucy
Hi,
Is there any a simple way to convert week number to date range. For example, if I have the data=3, then I would like to convert it to 1/11/2009 to 1/17/2009.
Thanks!
Lucy
If you look up DatePart in VBA help, you will see that the 1st week of the year can be defined at least 3 different ways.