How do I add 120 days to a cell that contains date and time?

[simmo512]

I have a single column of cells that contain both date and time. I need to add 120 days to the date, I'm actually not interested in the time, I just need to create a new column showing the date + 120 days.

e.g
mm/dd/yyy hh:mm AM/PM
10/27/2011 07:10 AM

Can someone suggest what formula I can use within a cell to add 120 days? I'm using Excel 2010.

Thanks

[Domski]

=INT(A1)+120

Dom

[brokenbiscuits]

=date(mid(j25,7,4),left(j25,2),mid(j25,4,2))+120
?

[Jon_Peltier]

If you want to include the time (which Dom's INT strips off), simply use

=A1+120

[Qualo_Jinn]

A few different way to approach it. If the number needs to change you can change the 120 (in any of the formulas) to a cell and input any number you want.

[raxhidpk]

i need which formula that i put date this 03.06.2012 and auto calculate after 120 days...like 03.09.2012 any one have this..so email me plz.
[email protected]
+923214884958