How do I autofill a list of sequential dates in Excel excluding Sunday? I want Monday April 8 to Saturday April 13, then back to Monday April 15.
Here is a basic way to do it
Fill the dates for the first week in the first six rows (say
In the seventh row, insert the following formula:
And populate down
Another way is to insert the first day in
A2 then use the following formula
and again, populate down
Your problem can be solved by using below shown method also:
How it works:
- Enter start date, 04/08/2019 in Cell
A1(Cell Format is
Write this Formula in Cell
A2& fill it down till you need.
Enter this formula in Cell
C1to justify the Formula in
Column A, and fill it Down also.
Adjust cell references in the Formula as needed.