Dates

[Melinda]

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

 

[Luke M]

M2:
=I2+30
N2:
=I2+60
O2:
=I2+90

 

[Mike H]

Melinda,

Put this in M2 and drag right

=L2+30

Mike

 

[Eduardo]

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

if this helps please click yes thanks

 

[David Biddulph]

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

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

if this helps please click yes thanks