Calculate number of weeks between two cells
 

How do I calculate the number of weeks between two cells?
Example

B2 = 1/1/08
B3 = 5/10/09
B4 = Formula for # of weeks between B2 and B3

Any assistance would be greatly appreciated.

Calculate number of weeks between two cells
 

One interpretation:

=INT((B3-B2)/7)


--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Jane Schuster" wrote in message
...
How do I calculate the number of weeks between two cells?
Example

B2 = 1/1/08
B3 = 5/10/09
B4 = Formula for # of weeks between B2 and B3

Any assistance would be greatly appreciated.