How do I calculate a future date in excel?

J

jcg

I can't figure out how to calculate a date.

if A1 contains a date of 01/01/2000
Then B1 should be 01/01/2003

How do I make that happen?

Helpless in Houston.
 
R

Richard Buttrey

I can't figure out how to calculate a date.

if A1 contains a date of 01/01/2000
Then B1 should be 01/01/2003

How do I make that happen?

Helpless in Houston.
Click to expand...



=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))

is one way

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top