Date function question

[Fletcher]

Hello,

I am trying to do a financial worksheet and I want to build a column that
starts with a certain date in A1 (let's say today, 7/23/2004) and then fill
it down through column A for the next several years, incrementing each cell
by 14 days (a pay period). So, the formula would look at A1, and add 14 days
to it for A2, (so A2 would have 8/6/2004) and on down the line.

Can someone tell me the formula for that?

Thanks!!

 

[Frank Kabel]

Hi
in A2 simply enter
=A1+14
and copy this down

 

[Norman Harker]

Hi Fletcher!

=A1+14
Format as a date.

Dates are serial numbers that represent the number of days since
31-Dec-1899. It is just that they are formatted to look like dates.

 

[Fletcher]

Well, that was waaaaaay too easy! thanks!