How to format a cell from date to week?
Ans 1:
=YEAR(A1)&WEEKNUM(A1)
Ans 2:
Assume A3 holds: 200950, and A4 holds 201002
=(LEFT(A4,4)-LEFT(A3,4))*53+RIGHT(A4,2)-RIGHT(A3,2)
"nginhong" wrote:
Dear all,
How to format a cell date like "2009-12-10" to year /week format "YYYYWW" =
200950?
Also how to determine number of weeks between 2 weeks like from 200950 to
201002 = 5 weeks?
BR//nginhong
|