Adding days to a date

E

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
 
D

Domenic

Hi,

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

=B2+2

Hope this helps!
 
H

hcj

=B2+2

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