How to add incremental dates in Microsoft Excel

1149700 pts.
Tags:
Microsoft Excel
For project tracking, I'm using Microsoft Excel. In one of my sheets, I have a column that I need to increment dates on a monthly basis. For example: Starting next Friday, I'll put in 6/1/2018. After that, I need Excel to add 7/1/2018, 8/1/2018, etc. How can I do that automatically?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

enter the first date in a cell, add the second date in the next cell.

Then select both cells and grab the handle (lower right) and drag as far out as you need the sequential dates.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: