Can I set up an excel doc to auto fill 27 days in next cell?
=a2+27 assuming de 10/01/2008 is in A2
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"mdj0615" escreveu:
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.
|