Calculating the Elapsed Time Between Two Dates in Days, Weeks and ... - Free Printable

Let’s solve each elapsed time problem step by step.

We’ll calculate the time between the Start Date and End Date in months, weeks, and days.

Important notes:
- We count full months first.
- Then we count full weeks (7 days) from the remaining days.
- Finally, leftover days.
- We assume a month is roughly 30 days for simplicity unless exact calendar math is needed — but since this is likely for school, we’ll use actual calendar differences where possible to be accurate.

Actually, let’s be precise: we’ll count the exact number of days between the two dates, then convert that into months, weeks, and days — but since “months” vary in length, the standard way in such worksheets is:

→ Count how many full months pass from start date to end date (by month name), then count remaining days, then break those days into weeks and days.

Example: From Aug 16, 1998 to Apr 9, 1999

Step 1: Count months from Aug 1998 to Apr 1999:
Aug → Sep (1), Oct (2), Nov (3), Dec (4), Jan (5), Feb (6), Mar (7), Apr (8) → so 8 months? But wait — from Aug 16 to Apr 16 would be exactly 8 months. But end date is Apr 9, which is before Apr 16. So we can only count 7 full months (to Mar 16, 1999), then add days from Mar 16 to Apr 9.

Better method:

Use this approach:

For each row:

1. Find the difference in years, months, days by subtracting start from end, adjusting for negative days/months.

But simpler for students:

Count months from start month to end month (same year or next), then adjust days.

Let me do each one carefully.

---

Row 1: Aug 16, 1998 to Apr 9, 1999

From Aug 16, 1998 to Apr 16, 1999 = 8 months
But end date is Apr 9, which is 7 days before Apr 16 → so subtract 7 days → 7 months and (30 - 7) = 23 days? No, that’s not right.

Better:

From Aug 16, 1998 to Mar 16, 1999 = 7 months
Then from Mar 16 to Apr 9 = 24 days (Mar has 31 days: 31-16=15, plus 9 = 24 days)

Now, 24 days = 3 weeks and 3 days (since 3*7=21, 24-21=3)

So: 7 months, 3 weeks, 3 days

Wait — let’s verify total days:

Aug 16, 1998 to Apr 9, 1999

Days in Aug 1998 after 16th: 31-16=15
Sep: 30
Oct: 31
Nov: 30
Dec: 31
Jan 1999: 31
Feb 1999: 28 (not leap year)
Mar: 31
Apr: 9

Total = 15+30+31+30+31+31+28+31+9 = let’s add:

15+30=45; +31=76; +30=106; +31=137; +31=168; +28=196; +31=227; +9=236 days

Now, 236 days ÷ 30 ≈ 7.86 months → so about 7 months and some days.

But we want months, weeks, days.

Standard way in these worksheets:

Count full months from start date to same day in later month.

From Aug 16, 1998 to Mar 16, 1999 = 7 months (Aug to Mar is 7 months)

Then from Mar 16 to Apr 9 = 24 days (as above)

24 days = 3 weeks and 3 days

So answer: 7 months, 3 weeks, 3 days

But let’s check if that matches total days: 7 months * 30 = 210, plus 24 = 234 — close to 236, off by 2 because months aren’t all 30 days. But for worksheet purposes, this is acceptable.

Actually, better to use exact day count and convert.

Total days = 236

236 ÷ 7 = 33 weeks and 5 days (since 33*7=231, 236-231=5)

But we need months, weeks, days — so we need to extract months first.

Perhaps the worksheet expects:

- Number of full calendar months between the dates (ignoring day), then remaining days.

I think for consistency, I’ll use this method:

For each pair:

1. Calculate total days between start and end (exclusive of start? inclusive? usually exclusive of start, inclusive of end? Let's assume we're calculating the duration from start date to end date, so if start is day 0, end is day N, then N days elapsed.

Actually, standard elapsed time: from date A to date B, the number of days is (B - A).

In Excel, =B-A gives days.

So for Aug 16, 1998 to Apr 9, 1999:

Using an online calculator or manual:

From Aug 16, 1998 to Apr 9, 1999 is 236 days (as calculated).

Now, to express in months, weeks, days:

We can say: 7 months and 24 days (since from Aug 16 to Mar 16 is 7 months, then 24 days to Apr 9)

Then 24 days = 3 weeks and 3 days

So: 7 months, 3 weeks, 3 days

Similarly for others.

Let me do all rows with this method.

---

Row 1: Aug 16, 1998 to Apr 9, 1999

Months: from Aug to Apr next year is 8 months, but since Apr 9 < Apr 16, we take 7 months (to Mar 16)

Days from Mar 16 to Apr 9: Mar has 31 days, so 31-16=15, plus 9 = 24 days

24 days = 3 weeks and 3 days

Answer: 7 months, 3 weeks, 3 days

---

Row 2: Jul 24, 2015 to Nov 11, 2015

Same year.

From Jul 24 to Nov 24 would be 4 months, but end is Nov 11, which is before Nov 24.

So from Jul 24 to Oct 24 = 3 months

Then from Oct 24 to Nov 11: Oct has 31 days, so 31-24=7, plus 11 = 18 days

18 days = 2 weeks and 4 days (14 + 4)

Answer: 3 months, 2 weeks, 4 days

---

Row 3: Jul 12, 2010 to Mar 21, 2011

From Jul 12, 2010 to Mar 12, 2011 = 8 months (Jul to Mar is 8 months)

Then from Mar 12 to Mar 21 = 9 days

9 days = 1 week and 2 days

Answer: 8 months, 1 week, 2 days

---

Row 4: May 4, 2001 to Sep 19, 2001

Same year.

From May 4 to Sep 4 = 4 months

Then from Sep 4 to Sep 19 = 15 days

15 days = 2 weeks and 1 day

Answer: 4 months, 2 weeks, 1 day

---

Row 5: Mar 24, 1991 to Jan 2, 1992

From Mar 24, 1991 to Jan 24, 1992 would be 10 months, but end is Jan 2, which is before Jan 24.

So from Mar 24 to Dec 24, 1991 = 9 months

Then from Dec 24, 1991 to Jan 2, 1992: Dec has 31 days, so 31-24=7, plus 2 = 9 days

9 days = 1 week and 2 days

Answer: 9 months, 1 week, 2 days

---

Row 6: Aug 17, 2013 to Jun 29, 2014

From Aug 17, 2013 to Jun 17, 2014 = 10 months (Aug to Jun next year is 10 months)

Then from Jun 17 to Jun 29 = 12 days

12 days = 1 week and 5 days

Answer: 10 months, 1 week, 5 days

---

Row 7: Feb 23, 1988 to Feb 18, 1989

From Feb 23, 1988 to Feb 23, 1989 = 12 months, but end is Feb 18, which is 5 days before.

So from Feb 23, 1988 to Jan 23, 1989 = 11 months

Then from Jan 23 to Feb 18: Jan has 31 days, so 31-23=8, plus 18 = 26 days

26 days = 3 weeks and 5 days (21 + 5)

Answer: 11 months, 3 weeks, 5 days

Note: 1988 is leap year, but since we're going from Feb 23, 1988 to Feb 18, 1989, and Feb 29, 1988 is included, but in our calculation, from Feb 23 to Jan 23 is 11 months, which includes the leap day, but since we're counting months by date, it should be fine. The extra day is absorbed in the month count.

Total days: from Feb 23, 1988 to Feb 18, 1989 is 361 days (since 1988 is leap year, 366 days in year, but from Feb 23 to Feb 23 is 366 days? No.

From Feb 23, 1988 to Feb 23, 1989 is exactly 366 days because 1988 is leap year and Feb 29 is included.

But end is Feb 18, 1989, which is 5 days before Feb 23, so 366 - 5 = 361 days.

361 days = 11 months and 26 days? 11 months * 30 = 330, 361-330=31, not matching.

Better stick with the calendar method.

From Feb 23, 1988 to Jan 23, 1989 = 11 months (Feb to Jan is 11 months)

Then Jan 23 to Feb 18: as above, 26 days.

Yes.

---

Row 8: Jul 31, 2007 to Nov 17, 2008

From Jul 31, 2007 to Jul 31, 2008 = 12 months

But end is Nov 17, 2008, which is after Jul 31, 2008.

From Jul 31, 2007 to Nov 31, 2007 would be 4 months, but Nov has only 30 days, so better:

From Jul 31, 2007 to Oct 31, 2007 = 3 months

Then from Oct 31 to Nov 17 = 17 days (since Oct 31 to Nov 17 is 17 days)

But we have to go to Nov 17, 2008, not 2007.

Mistake.

Start: Jul 31, 2007

End: Nov 17, 2008

So from Jul 31, 2007 to Jul 31, 2008 = 12 months

Then from Jul 31, 2008 to Nov 17, 2008

From Jul 31 to Aug 31 = 1 month, but Aug has 31 days, so from Jul 31 to Aug 31 is 1 month.

Then Aug 31 to Sep 30 = 1 month? Better to count months from Jul 31.

From Jul 31, 2008 to Nov 31, 2008 would be 4 months, but Nov has 30 days, and end is Nov 17.

So from Jul 31, 2008 to Oct 31, 2008 = 3 months

Then from Oct 31 to Nov 17 = 17 days

So total: 12 months (to Jul 31, 2008) + 3 months (to Oct 31, 2008) = 15 months? That can't be right because from Jul 2007 to Nov 2008 is about 16 months.

Let's calculate total months.

From Jul 2007 to Nov 2008 is 16 months (Jul to Nov is 4 months, but from 2007 to 2008 is 12 months, so 12 + 4 = 16 months, but from Jul 31 to Nov 31 is 4 months, but Nov 17 is before Nov 31.

From Jul 31, 2007 to Nov 31, 2008 is 16 months.

But end is Nov 17, 2008, which is 14 days before Nov 31.

So from Jul 31, 2007 to Nov 17, 2008 = 16 months minus 14 days.

But 16 months minus 14 days is not standard.

Better: from Jul 31, 2007 to Nov 31, 2007 = 4 months

Then from Nov 31, 2007 to Nov 31, 2008 = 12 months, but Nov 31 doesn't exist.

This is messy.

Let's use the day count.

From Jul 31, 2007 to Nov 17, 2008

Days in 2007 after Jul 31: Aug to Dec = 31+30+31+30+31 = 153 days? Let's calculate:

Aug: 31, Sep: 30, Oct: 31, Nov: 30, Dec: 31 = 31+30=61; +31=92; +30=122; +31=153 days in 2007 after Jul 31.

But from Jul 31 to Aug 1 is 1 day, so from Jul 31 to Dec 31 is 153 days? No.

If start is Jul 31, then days from Jul 31 to Aug 1 is 1 day, so to Dec 31 is the number of days from Jul 31 to Dec 31 inclusive or exclusive?

Standard: number of days from date A to date B is (B - A).

From Jul 31, 2007 to Dec 31, 2007 is 153 days (since Jul has 31 days, so from Jul 31 to Aug 1 is 1 day, to Sep 1 is 32 days, etc. Better to use a different approach.

I recall that from Jul 31, 2007 to Jul 31, 2008 is 366 days because 2008 is leap year? 2008 is leap year, but from Jul 31, 2007 to Jul 31, 2008 is exactly 365 days because the leap day is Feb 29, 2008, which is within this period, so yes, 366 days.

2008 is leap year, so from Feb 29, 2008 is included, so from Jul 31, 2007 to Jul 31, 2008 is 366 days.

Then from Jul 31, 2008 to Nov 17, 2008.

From Jul 31 to Aug 31 = 31 days (but from Jul 31 to Aug 31 is 31 days? From Jul 31 to Aug 1 is 1 day, to Aug 31 is 31 days.

Then Sep 30, Oct 31, Nov 17.

So from Jul 31, 2008 to Nov 17, 2008:

Aug: 31 days (from Jul 31 to Aug 31 is 31 days, but that's to Aug 31, then from Aug 31 to Sep 30 is 30 days, etc.

Let's calculate cumulative:

From Jul 31, 2008 to Aug 31, 2008 = 31 days

To Sep 30, 2008 = 31 + 30 = 61 days

To Oct 31, 2008 = 61 + 31 = 92 days

To Nov 17, 2008 = 92 + 17 = 109 days? From Oct 31 to Nov 17 is 17 days, yes.

But from Jul 31 to Nov 17 is not 109 days because from Jul 31 to Aug 1 is 1 day, to Aug 31 is 31 days, to Sep 30 is 31+30=61 days, to Oct 31 is 61+31=92 days, to Nov 17 is 92+17=109 days. Yes.

So total from Jul 31, 2007 to Nov 17, 2008 = days in 2007 after Jul 31 + days in 2008 up to Nov 17.

Days in 2007 after Jul 31: from Aug 1 to Dec 31 = 31+30+31+30+31 = 153 days, but since we start from Jul 31, the first day is Aug 1, so from Jul 31 to Dec 31 is 153 days? Let's think.

If today is Jul 31, tomorrow is Aug 1, so from Jul 31 to Aug 1 is 1 day elapsed.

So from Jul 31, 2007 to Dec 31, 2007 is the number of days from Aug 1 to Dec 31 inclusive? No.

Standard calculation: the number of days between two dates is the difference.

From date A to date B, days = B - A.

For example, from Jan 1 to Jan 2 is 1 day.

So from Jul 31, 2007 to Aug 1, 2007 is 1 day.

From Jul 31, 2007 to Dec 31, 2007 is 153 days (since there are 153 days from Aug 1 to Dec 31, but from Jul 31 to Dec 31 is 153 days because Jul 31 to Aug 1 is 1, to Sep 1 is 32, to Oct 1 is 63, to Nov 1 is 94, to Dec 1 is 124, to Dec 31 is 153 days. Yes.

Then from Jan 1, 2008 to Nov 17, 2008.

2008 is leap year, so Jan to Oct is 31+29+31+30+31+30+31+31+30+31 = let's calculate: Jan 31, Feb 29, Mar 31, Apr 30, May 31, Jun 30, Jul 31, Aug 31, Sep 30, Oct 31 = 31+29=60; +31=91; +30=121; +31=152; +30=182; +31=213; +31=244; +30=274; +31=305 days to Oct 31.

Then Nov 1 to Nov 17 = 17 days, so to Nov 17 is 305 + 17 = 322 days from Jan 1 to Nov 17.

But from Jan 1 to Nov 17 is 322 days? Jan 1 to Jan 2 is 1 day, so to Nov 17 is the number of days from Jan 1 to Nov 17 inclusive or exclusive.

From Jan 1 to Nov 17 is 321 days if we consider Jan 1 as day 0, but usually, from Jan 1 to Nov 17 is 321 days elapsed if Nov 17 is the end date.

Let's clarify.

If start date is S, end date is E, then elapsed days = E - S.

For example, from Jan 1 to Jan 2, elapsed days = 1.

From Jan 1 to Dec 31, elapsed days = 364 or 365? In a non-leap year, from Jan 1 to Dec 31 is 364 days, because Dec 31 - Jan 1 = 364.

In Excel, =DATE(2007,12,31)-DATE(2007,1,1) = 364.

So for our case:

From Jul 31, 2007 to Dec 31, 2007 = DATE(2007,12,31) - DATE(2007,7,31) = let's calculate: July has 31 days, so from Jul 31 to Aug 1 is 1, to Sep 1 is 32, to Oct 1 is 63, to Nov 1 is 94, to Dec 1 is 124, to Dec 31 is 124 + 30 = 154 days? From Dec 1 to Dec 31 is 30 days, so from Jul 31 to Dec 31 is 154 days.

Let's use a reliable method.

I can use the fact that from Jul 31, 2007 to Jul 31, 2008 is 366 days (since 2008 is leap year, and Feb 29 is included).

Then from Jul 31, 2008 to Nov 17, 2008.

From Jul 31 to Aug 31 = 31 days ( but from Jul 31 to Aug 31 is 31 days, as Aug 31 - Jul 31 = 31)

Then from Aug 31 to Sep 30 = 30 days

Sep 30 to Oct 31 = 31 days

Oct 31 to Nov 17 = 17 days

So total from Jul 31, 2008 to Nov 17, 2008 = 31 + 30 + 31 + 17 = 109 days

So total elapsed days = 366 + 109 = 475 days

Now, 475 days to months, weeks, days.

First, find how many full months.

From Jul 31, 2007 to Nov 31, 2008 would be 16 months, but Nov 31 doesn't exist, so to Nov 30, 2008 is 16 months from Jul 31, 2007? Let's see.

From Jul 31, 2007 to Aug 31, 2007 = 1 month

To Sep 30, 2007 = 2 months

To Oct 31, 2007 = 3 months

To Nov 30, 2007 = 4 months

To Dec 31, 2007 = 5 months

To Jan 31, 2008 = 6 months

To Feb 29, 2008 = 7 months (since 2008 is leap year)

To Mar 31, 2008 = 8 months

To Apr 30, 2008 = 9 months

To May 31, 2008 = 10 months

To Jun 30, 2008 = 11 months

To Jul 31, 2008 = 12 months

To Aug 31, 2008 = 13 months

To Sep 30, 2008 = 14 months

To Oct 31, 2008 = 15 months

To Nov 30, 2008 = 16 months

But our end date is Nov 17, 2008, which is before Nov 30.

So from Jul 31, 2007 to Oct 31, 2008 = 15 months

Then from Oct 31, 2008 to Nov 17, 2008 = 17 days

17 days = 2 weeks and 3 days (14 + 3)

So answer: 15 months, 2 weeks, 3 days

Total days: 15 months * 30 = 450, plus 17 = 467, but we have 475, so off by 8 days, but for worksheet, this is acceptable.

Since the worksheet likely expects this method, I'll go with it.

So for row 8: 15 months, 2 weeks, 3 days

---

Row 9: Nov 21, 1988 to Aug 13, 1989

From Nov 21, 1988 to Aug 21, 1989 = 9 months (Nov to Aug is 9 months)

But end is Aug 13, which is before Aug 21, so from Nov 21, 1988 to Jul 21, 1989 = 8 months

Then from Jul 21 to Aug 13: Jul has 31 days, so 31-21=10, plus 13 = 23 days

23 days = 3 weeks and 2 days (21 + 2)

Answer: 8 months, 3 weeks, 2 days

---

Row 10: Nov 16, 1986 to Nov 9, 1987

From Nov 16, 1986 to Nov 16, 1987 = 12 months, but end is Nov 9, which is 7 days before.

So from Nov 16, 1986 to Oct 16, 1987 = 11 months

Then from Oct 16 to Nov 9: Oct has 31 days, so 31-16=15, plus 9 = 24 days

24 days = 3 weeks and 3 days

Answer: 11 months, 3 weeks, 3 days

---

Now, let's compile all answers:

1. Aug 16, 1998 to Apr 9, 1999: 7 months, 3 weeks, 3 days

2. Jul 24, 2015 to Nov 11, 2015: 3 months, 2 weeks, 4 days

3. Jul 12, 2010 to Mar 21, 2011: 8 months, 1 week, 2 days

4. May 4, 2001 to Sep 19, 2001: 4 months, 2 weeks, 1 day

5. Mar 24, 1991 to Jan 2, 1992: 9 months, 1 week, 2 days

6. Aug 17, 2013 to Jun 29, 2014: 10 months, 1 week, 5 days

7. Feb 23, 1988 to Feb 18, 1989: 11 months, 3 weeks, 5 days

8. Jul 31, 2007 to Nov 17, 2008: 15 months, 2 weeks, 3 days

9. Nov 21, 1988 to Aug 13, 1989: 8 months, 3 weeks, 2 days

10. Nov 16, 1986 to Nov 9, 1987: 11 months, 3 weeks, 3 days

I think this is correct for the worksheet's expectation.

Final Answer:

7 months, 3 weeks, 3 days
3 months, 2 weeks, 4 days
8 months, 1 week, 2 days
4 months, 2 weeks, 1 day
9 months, 1 week, 2 days
10 months, 1 week, 5 days
11 months, 3 weeks, 5 days
15 months, 2 weeks, 3 days
8 months, 3 weeks, 2 days
11 months, 3 weeks, 3 days