Thread: Excel Spreading dates evenly in a row of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Excel Spreading dates evenly in a row of cells
In A2 enter:
=A1+($A$10-$A$1)/9 and copy down. Then format as date.
--
Gary''s Student - gsnu200838


"OHNESORGE" wrote:

I have a start date in Cell A1-Dec 1, 2008
I have a complteion date in cell A10-Dec 30,2008
I need the cells A2-A9 to reflect the dates spread out evenly amongst them.
Reply With QuoteReply With Quote