Looking for ideas

[viper]

How can I test for the number of weeks between two cells that contain dates? I have the date 2/27/02 in cell "b5" and the date 3/27/02 in cell "A1", how can write a formula to take the number of days between those two cells and divide by 7 to give me a number of weeks?

 

[Guest]

=(A1-B5)/7

 

[viper]

Thanks,

Just wasn't thinking about a simple formula, thought I needed something more but it worked great.

Thanks again,