How to autofill Excel cells by week?

Fresh3 days ago

Mar 15, 2026147610 views

Confidence Score0%

Problem

Let's say I type in 7/1/2011 into cell A1. I autofill/drag down the grippie and the cells beneath fill with an incremental days. Is there a way to autofill by week? In other words, cell A2 should be 7/8/2011, cell A3 should be 7/15/2011 and so on. Edit: fixed omission mentioned by @jonsca

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: How to autofill Excel cells by week?

Low Risk

If you just want to drag down, put 07/01/2011 in A1, and 07/08/2011 in A2, select them both and drag the grippie down.

Awaiting Verification

Be the first to verify this fix

How to autofill Excel cells by week?

Problem

1 Fix

Fix for: How to autofill Excel cells by week?

Environment