If I change a date in a date column how do I get the dates below .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with dates. When I change a date I want all the dates below
the one I've changed to change automatically? How would I do this in Excel?
Thanks!
 
One way is to enter a date in A1.
In A2 enter this formula:
=A1+1
And copy it down as far as needed.
 
You didn't specify quite enough. Do you want the dates
below the one changed to be equal to the new date?? This
seems too easy, so I must not understand. If the cell that
you put the new date into is "A1", then in subsequent date
cells in column "A" you can write =A1, i.e., just let the
others copy whatever is in cell A1.
 
You must log in or register to reply here.

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

Excel Excel due and overdue date colours 2
Excel Vba to change displayed year automatically. 14
Remove date format? 3
Using Dates with the IF function 2
Changing dates automatically with the computer date 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Date changes in data 1
Excel Message box with days of month & date. 1

Back
Top