Adding days to a date

[Edge118]

Hi,

I have a cell with a date stored in it. I want to know if I can us
a formula to add 2 days to the stored date and display it in anothe
cell. So if cell B2 stores "June 2", I want to store "June 4" in C2 b
adding 2 days to the date in B2. Thanks for your help!

R

 

[Domenic]

Hi,

As long as the date in B2 is a true date, you can use the following
formula:

=B2+2

Hope this helps!

 

[ray]

Hi
Format b2 to date and enter =a1+2

 

[hcj]

=B2+2

Dates are stored as serial days, so date math is in terms
of days by default.

 

[popgroove]

this should work, in cell C2 type

=B2 + 2

Mark Wielgus
www.AutomateExcel.co