98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic training excel - Excel formulas - calculating between dates | Excel forum
basic training excel - Excel formulas - calculating between dates | Excel forum
Resolved · Low Priority · Version Standard
Thu 8 Mar 2007, 14:46Delegate Lucy said...
Lucy has attended:
Excel Intermediate course
Excel Advanced course
Excel formulas - calculating between dates
Good afternoon,
I need to find a formula that calculates the amount of weeks in betweek a Start Date and an End date.
Thank you.
Lucy
Thu 8 Mar 2007, 16:35Trainer Tracy said...
RE: Excel Formulas
Hi Lucy,
What I suggest is you plug in a date in one cell (A1) and another later date in another cell (B1) then you do a simple calculation (B1-A1). The trick will be to format the answer in the correct way.
If you format the answer to Format>Cells>number you will get the number of days, make sure you have 0 decimal places. However you could try (B1-A1)/7 to give you the number of weeks.
Good luck
Tracy
Tue 13 Mar 2007, 12:37Delegate Louise said...
RE: Excel Formulas
I agree with the previous reply - except for perhaps the formatting.
For example: To divide 10 days by 7 would give a result of 1.429 weeks. If you want it to show as weeks and days, format the cell using:
format cell --> fraction --> custom --> change # ?/? to # ?/7.
This would give 10 days as 1 1/7.
Other uses are for imperial measurements.
Wed 14 Mar 2007, 09:35
Edited on Wed 14 Mar 2007, 09:36Trainer Tracy said...
RE: Excel Formulas
Hi Lucy,
If you use the formula =days360(start date, end date) this will give you the number of days. Once you have got this you can divide the answer by 7 to get the number of weeks.
For example: =360days(20/02/07:28/02/07)/7 will give you the answer 1, formatted to 0 decimal places (=1 week)
Hope this helps
Tracy
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Wrapping Text in a Cell in an Excel 2010 WorkbookWhen you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER. |
