Dates
 

I have a date in cell l2 of 9/16/09 and I need in cell m2 to be 30 days after
the date in l2, n2 to be 60 days after l2, and o2 to be 90 days after l2----
I need a formula that will work--- please


Thanks

Dates
 

M2:
=I2+30
N2:
=I2+60
O2:
=I2+90
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Melinda" wrote:

I have a date in cell l2 of 9/16/09 and I need in cell m2 to be 30 days after
the date in l2, n2 to be 60 days after l2, and o2 to be 90 days after l2----
I need a formula that will work--- please


Thanks

Dates
 

Melinda,

Put this in M2 and drag right

=L2+30

Mike

"Melinda" wrote:

I have a date in cell l2 of 9/16/09 and I need in cell m2 to be 30 days after
the date in l2, n2 to be 60 days after l2, and o2 to be 90 days after l2----
I need a formula that will work--- please


Thanks

Dates
 

Hi,
try
=DATE(YEAR(L2), MONTH(L2), DAY(L2)+30)

if this helps please click yes thanks

"Melinda" wrote:

I have a date in cell l2 of 9/16/09 and I need in cell m2 to be 30 days after
the date in l2, n2 to be 60 days after l2, and o2 to be 90 days after l2----
I need a formula that will work--- please


Thanks

Dates
 

Isn't =L2+30 easier?
--
David Biddulph

"Eduardo" wrote in message
...
Hi,
try
=DATE(YEAR(L2), MONTH(L2), DAY(L2)+30)

if this helps please click yes thanks

"Melinda" wrote:

I have a date in cell l2 of 9/16/09 and I need in cell m2 to be 30 days
after
the date in l2, n2 to be 60 days after l2, and o2 to be 90 days after
l2----
I need a formula that will work--- please


Thanks