H
haviv
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
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