View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default calculate a particular date

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