Thread: date function
View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

if your 9/5/2005 is in Cell A1
=A1+14
will give you a date 14 days later
You can do this for each of the datys you want to have.

"Mark" wrote:

I have two cells. One represents date in 09/05/2005 format. I need a formula
for another cell to return a date that is 14 days later and be formated the
same way.

Is it possible to have o formula to return each day for the above mentioned
14-day period (one forula per day) to get all 14 days prefilled ?

Thanks.

Mark