Date-increments

R

Robert Dieckmann

Is there a way to increment dates by month based off a key cell? For
example if cell A1 contains 01/01/2004 then A2 I want to be 02/01/2004; A3
to be 03/01/2004 etc. If I change cell A1 to 04/10/2004 then I want A2 to
automatically change to 05/10/2004; A3 to change to 06/10/2004 etc. I am
using Excel 2000.

Thanks.
Robert
 
C

Chip Pearson

With your start date in A1, use the following formula

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
 
H

Harald Staff

Hi Robert

A2:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
fill down. Note that Excel makes a distinct choice on what January 31st + 1
month is, which may or may not fit your needs.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuous Invoice Nos. 3
Change the text colour of a cell when opening up a sheet 5
date & month 6
pull data from one table to another if multiple conditions are met 3
Tricky Scenario finding days/months/years! 3
If statement with dates 0
Extracting the Month value from a fully qualified date column 5
Conditional Formatting - Dates 2

Top