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

**simmo512** · 07-15-2011, 09:50 AM

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** · 07-15-2011, 09:51 AM

=INT(A1)+120

Dom

**brokenbiscuits** · 07-15-2011, 09:54 AM

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

**Jon_Peltier** · 07-15-2011, 10:15 AM

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

=A1+120

**Qualo_Jinn** · 07-15-2011, 10:17 AM

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** · 11-15-2012, 02:03 PM

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.
raxhidpk@gmail.com
+923214884958