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?

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...
--
Kevin Backmann


"Felicity" wrote:

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?

=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)



"Felicity" wrote in message
...
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?

=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.
--
David Biddulph

"Felicity" wrote in message
...
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?