date function

M

Mark

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
 
C

Cutter

If your original date is in A1

In B1 type: =A1+1

Drag copy this formula across the columns until you have your 14 days

Format all your columns to your required date forma
 
B

bj

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