calculate a particular date

F

Felicity

I have a row of different date when people joined a study. I need to
calculate the exact date three months afterwards. How do I create a formular,
so I don't have to calculate it separately for each different person(given
that thye joined on different dates?
 
K

Kevin B

Add 90 to the cell that has the date.

If Cell A1 has the date of 10/15/1979 the following formula in cell B1 will
produce the date of 1/13/1980

=A1+90

Hope this helps...
 
B

Bob Phillips

=MIN(DATE(YEAR(A1),MONTH(A1)+{4,3},DAY(A1)*{0,1}))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
D

David Biddulph

=DATE(YEAR(A2),MONTH(A2)+3,DAY(A2))
or
=EDATE(A2,3) [check Excel help if you get a #NAME! error from this one]

Usual notes of caution apply, such as the question as to what you regard as
being 3 months after 30th November. The 2 formulae above give 2 different
results.
 
Top