I need a formula that change all date by putting in one date

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

Guest

I am not real verse with formulas and I need to get a formula that if I
change one date that all the other dates following would change by one.

How would I do this?
 
Dates are numbers

If you have a Date in A1 you can use this formula in B1
=A1+1 to add one day
 
Hi sherrie,

Is this what you mean?

If your date is in A1

then in A2 put

=A1+1 and copy this down

oldchippy :
 
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 Average dates help 0
Excel Dragging countif formula with changing criteria 3
Workday Formula to include date 0
names dates & amounts stated multiple times in document 0
Excel 2003 make 1 date cell automatically change another date cell 3
Help needed with a formula for dates in excel 2007 2
Can I update a date formula only if checkbox changes? 1
Formula Based on Values in Named Range Q 3

Back
Top