Calculate the number of week & days between two dates

[mulberry13]

Does anyone have an example of counting the # weeks/days between two dates?

 

[Arul.rajesh]

You can subtract dates in excel, as Excel stores dates as serial numbers. if you end up with a negative result dont panic if excel shows "#######" just format the cell as general.

As far as calculating weeks goes, divide the difference by seven to get the number of weeks.
<a href="http://www.imagehousing.com/image/862552"><img border="0" src="http://img1.imagehousing.com/82/7f46f3e2181baac798cd1128215e25e8.gif" alt="Free Image Hosting"></a>