ok im wondering if any of you guys can help me... i need a formula that when i enter a date in one box, the next box will show the date 13 days later...

ie

09/16/2008 - 09/29/2008


10/10/2008 - 10/23/2008


11/30/2008 - 12/13/2008

anyone have any ideas?

 

yup I got you... just enter the box with the date you want to start with in first (let's say 09/16/2008 is A1). Make sure you have the boxes formatted correctly to represent the correct MM/DD/YYYY. In the next box (let's say it's B1) you want it to show the first date + 13, so in B1 put "=A1+13" then press enter...VIOLA!

 

yeah just put in =cell number+13

like

=A1+13

make sure the cells your going from and to are all formatted to DATE if you have any problems pm me or something, i get those quicker than i would on here.

 

=/ sorry i posted the exact same thing.. i'm at work so i sat on the page for a few minutes

 

lol, that was way easier than the stuff i was trying to think of....thanks guys...completely overlooked it.