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

Hi Haviv,

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

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

"haviv" <(E-Mail Removed)> wrote in message news:64599C8C-BF08-4D20-A52A-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message news:64599C8C-BF08-4D20-A52A-(E-Mail Removed)...
> >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
>