convert yyyy-ww date to actual date

[Pierre]

Have a string of dates of produced items. All the dates are mmmm-mm
(2007-06), for the 6th week in 2007 for instance. Looking for a
formula to have it enter a date in a helper column which will place it
into any given quarter: IOW, they can all be Mondays, but I'll need a
date such as 02/05/07 to load into a pivot table, that will group
production items by the quarter they were produced.

TIA for any thoughts.

Pierre

 

[Peo Sjoblom]

Maybe something like

=DATE(LEFT(A1,4),1,0)+RIGHT(A1,2)*7

if it is always text

--


Regards,


Peo Sjoblom

 

[Pierre]

Maybe something like

=DATE(LEFT(A1,4),1,0)+RIGHT(A1,2)*7

if it is always text

--

Regards,

Peo Sjoblom








- Show quoted text -

Did the trick. Thank you!!

Pierre