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
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
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.
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
