Adding number of days to a date formatted cell

[cvall84]

Quick question that seemed simple but I can't quite figure out, I have a date 5/5/2011 and in the next cell I have a number of days say "365" now I want to add the 365 to the date formatted cell to get the future date of 5/5/2011 365 days later. Any help?

 

[Jonmo1]

Try

=A1+B1

A1 = Your Date
B1 = 365

 

[Akashwani]

Hi,

So what result are you getting?

Excel Workbook
	A
1	05/05/2011
2	365
3	04/05/2012
Sheet3

Ak

 

[JB_Scotland]

Just add 365 to the date!

Old Date (A1): 5/5/2010
New Date (A2): = A1 + 365
Result (A2): 5/5/2011

Format both A1 and A2 as dates.