date function
 

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

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 format


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401934

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