calculate a particular date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Felicity - 28 May 2008 16:11 GMT

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?

Reply to this Message

Kevin B - 28 May 2008 16:17 GMT

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

Signature

Kevin Backmann

> 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?

Reply to this Message

Bob Phillips - 28 May 2008 16:53 GMT

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

Signature

---
HTH

Bob

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

>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?

Reply to this Message

David Biddulph - 28 May 2008 16:57 GMT

=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

Reply to this Message