Wednesday, September 26, 2012

How to Calculate Weeks Days Between Two Given Dates in Excel 2003


1. Left-click on the cell you want the result to formulate within.
2. Type in the formula in the cell you selected in step 1 to calculate the amount of days. For example, if the two dates are A2 ('6/9/2004') and A3 ('8/21/2004'), you would subtract A3 from A2 to find out the days and weeks in between. The formula would look like this: ' =(A3 - A2) '
3. Press the 'Enter' key on your keyboard to formulate the result. For example, if you enter the formula using the data in step 2, you would end up with 72 days between the two dates.
4. Select another cell where you wish to input your formula to convert the number of days to weeks.
5. Enter the formula into the newly selected cell beginning with the ' = ' sign and clicking on the cell you selected in step 1. Add a '/' sign followed by the number '7.' This will take the result you found in step 1 and divide it by 7 to find the amount of weeks between the two dates.
6. Press the 'Enter' key on your keyboard to find the number of weeks between the two dates.

Blogger news