# How to get the start and end dates of last week in Excel

Go back to this week's Monday and 7 more days: `=A2-WEEKDAY(A2,3)-7`. Add 6 for last week's Sunday.

**Excel:** `=A2-WEEKDAY(A2,3)-7` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B |
| --- | --- |
| Report date | Last week starts |
| 2026-10-29 |  |
| 2026-11-02 |  |
| 2026-11-08 |  |
| 2027-01-01 |  |
| 2026-03-02 |  |

Formula in B2, filled to B6: `=A2-WEEKDAY(A2,3)-7`

Result: 10/19/2026; 10/26/2026; 10/26/2026; 12/21/2026; 2/23/2026

## How it works

`A2-WEEKDAY(A2,3)` is the Monday of the current week, and 7 days earlier is the Monday of last week. The week ends 6 days after it, on Sunday, so `=B2+6` gives the end date.

## Other ways

- `=A2-WEEKDAY(A2,2)-6`: The same with Monday = 1 numbering.
- `=A2-WEEKDAY(A2)-6`: For Sunday-to-Saturday weeks: last week's Sunday. (Returns a Sunday.)

## Common mistakes

- Decide whether weeks start on Sunday or Monday, and use the matching WEEKDAY type everywhere.
- On a Monday, "last week" is the full week that ended yesterday, not the past 7 days.

## Questions

**How do I get the end of last week?**

`=A2-WEEKDAY(A2,3)-1` returns last Sunday.

**How do I total last week's sales?**

`=SUMIFS(amounts,dates,">="&B2,dates,"<="&B2+6)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/start-and-end-dates-of-last-week