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

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

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.

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