View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mdj0615 mdj0615 is offline
external usenet poster
 
Posts: 13
Default Can I set up an excel doc to auto fill 27 days in next cell?

I am trying to create a spreadsheet where I can enter a date and have a date
27 days from that date pop into the cell next to it. I need to do this for 7
months. I don't even know if it's possible.

For example, if I put the date 10/01/2008 into a cell, I want the
spreadsheet to calculate 27 days and put that date into the next cell
(10/28/2008). I want it to do that for 7 cells.