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.
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.
On Thu, 8 Sep 2005 14:31:14 -0700, jcg <[email protected]>
wrote:
>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.
=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))
is one way
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks