Date Problems

I am working on a file where the date format is given at YYYY/WW

The Year is pretty self explanatory

The week, however, is a little different.

--Week 01 is the first week in February.
--Week 02 is the second week in February, beginning with the first Saturday, if the first Saturday wasn't 02.-01-YYYY

So if the Date if 200801, then the Dating is 1-27-08 through 2-01-08.

With these stipulations, can any help me convert my Date format into Begin and End Date in a DD-MM-YY format.

Thanks in advance for any help I can get.
Best,
M

Originally Posted by mchesnu

So if the Date if 200801, then the Dating is 1-27-08 through 2-01-08.

If weeks start on Saturdays shouldn't 200801 start on 1-26-08?

Presumably 2008/51 would be a date in 2009?

Assuming that's the case then with your data in A2 (in either YYYY/WW or YYYYWW format) try this formula in B2 to give start date of that week

=DATE(LEFT(A2,4),2,RIGHT(A2,2)*7-5)-WEEKDAY(DATE(LEFT(A2,4),2,2))

obviously if you want end date too then you can just add 6 days, i.e. in C2

=B2+6