Adding 28 days to a date
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
|