I'm having a bit of trouble coming up with the right formula to use here. I hope this is easy to follow.
In cell A3 of my worksheet I used the TODAY function for the date (as instructed).
In cell A5 I had to key a formula that adds 1 day to the date in cell A# (which is today's actual date). I used the formula =today()+1; which gave me May 16, 2009.
Next, I need to use a formula in cell A6 that adds one day to the date in cell A5, then copy this formula down to row 25. This is where I'm getting stuck...I think.
I end up with the same date that is in cell A5 all of the way down to row 25. I checked help but I'm having a lot of trouble finding the proper way to do this.
I hope this makes sense, any guidance would be appreciated.
In cell A3 of my worksheet I used the TODAY function for the date (as instructed).
In cell A5 I had to key a formula that adds 1 day to the date in cell A# (which is today's actual date). I used the formula =today()+1; which gave me May 16, 2009.
Next, I need to use a formula in cell A6 that adds one day to the date in cell A5, then copy this formula down to row 25. This is where I'm getting stuck...I think.
I end up with the same date that is in cell A5 all of the way down to row 25. I checked help but I'm having a lot of trouble finding the proper way to do this.
I hope this makes sense, any guidance would be appreciated.