View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_2_] James Silverton[_2_] is offline
external usenet poster
 
Posts: 115
Default 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