Adding 28 days to a date

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

Guest

Hi

I was wondering if anyone knew of a way of typing a date for example
01/01/07 and then when you drag the crosshaire into the next cell instead of
it saying 02/01/07 it adds 28 days on to it so it says 28/01/07 and so on

Regards Joel
 
Instead of dragging just enter "=a1+28" into the next cell. (assuming
the first date is in cell a1) See xl help for times and dates.
 
Joel wrote on Wed, 10 Oct 2007 08:22:00 -0700:

J> I was wondering if anyone knew of a way of typing a date for
J> example 01/01/07 and then when you drag the crosshaire into
J> the next cell instead of it saying 02/01/07 it adds 28 days
J> on to it so it says 28/01/07 and so on

Off the top of my head, suppose the date is in A2, make a1
=a2-28, cut and special paste its value into A1, set A2=a1+28.
Then pulling the tab will do the trick. Not very elegant but it
works.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
 
Back
Top