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

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

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

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.