Date function question

  • Thread starter Thread starter Fletcher
  • Start date Start date
F

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!!
 
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.
 
Back
Top