calculate week difference
 

I have two cells container year and week number. They in format yyyyww.
Examples

cell 1 200712 --- week 12 in 2007
cell 2 200813 --- week 13 in 2008

What formula do I need to use to calculate the week differences between both
cells so i can get the week difference between them is 53 weeks or 12,25
months

--
Sincerely Yours
Haviv

calculate week difference
 

Hi Haviv,

Try:
=(INT(B1/100)-INT(A1/100))*52+MOD(B1,100)-MOD(A1,100)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"haviv" wrote in message ...
I have two cells container year and week number. They in format yyyyww.
Examples

cell 1 200712 --- week 12 in 2007
cell 2 200813 --- week 13 in 2008

What formula do I need to use to calculate the week differences between both
cells so i can get the week difference between them is 53 weeks or 12,25
months

--
Sincerely Yours
Haviv

calculate week difference
 

thanks
--
Sincerely Yours
Haviv


"macropod" wrote:

Hi Haviv,

Try:
=(INT(B1/100)-INT(A1/100))*52+MOD(B1,100)-MOD(A1,100)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"haviv" wrote in message ...
I have two cells container year and week number. They in format yyyyww.
Examples

cell 1 200712 --- week 12 in 2007
cell 2 200813 --- week 13 in 2008

What formula do I need to use to calculate the week differences between both
cells so i can get the week difference between them is 53 weeks or 12,25
months

--
Sincerely Yours
Haviv