How To Fill Date By Week In Excel Quickly And Easily?

Visit the Page ⇒

 Autofill Date Weekly With Formula

To fill date weekly, you can apply a simple formula.

1. Select a cell and type the start date. In our case, we type 3/1/2016 in Cell A1. See screenshot:
doc fill date weekly 1

2. Then in the next cell, A2, type this formula =A1+7, and press Enter key to get the second date. See screenshot:
doc fill date weekly 2

And now you can drag the Cell A2’s autofill handle down to fill dates weekly as you need. See screenshot:
doc fill date weekly 3

Categories
Tags
AJAX Android APIs AWS Bootstrap Browsers Cache Customization DNS Documentation Domain name Editor Evernote excerpt Flowcharts Function GeneratePress Gmail Group HDD JSON Links Maintenance Material memberpress Membership Memory Message Online Courses registration Regular Expression Restrict Access SATA Security Site Performance Source Codes Spreadsheet Strip SVG Tooltip Tutorials Utility Vector Video Widgets