Hi - I would like to calculate a child's age into months. For example, if a
child is 1 year old, the cell would read '12' months old.

What's more important, I don't want to round up to the nearest month. So,
if a child turned 12months on 12/15/09 (born 12/15/08) and today is 1/6/2010,
I would like it to round down to 24months.

It would only turn 25months if today was 1/15/2010.

Regards, Meg

Use the datedif function something like this...

=DATEDIF(A1, TODAY(), "m")

Here is a link on using datedif
http://www.cpearson.com/excel/datedif.aspx
--
HTH...

Jim Thomlinson


"Meg" wrote:

> Hi - I would like to calculate a child's age into months. For example, if a
> child is 1 year old, the cell would read '12' months old.
>
> What's more important, I don't want to round up to the nearest month. So,
> if a child turned 12months on 12/15/09 (born 12/15/08) and today is 1/6/2010,
> I would like it to round down to 24months.
>
> It would only turn 25months if today was 1/15/2010.
>
> Regards, Meg

I'm confused!

If the birth date is 12/15/2008 and today is 1/6/2010 then their age in
(full) months is 12. How do you get 24 or 25? They wouldn't be 24 months old
until 12/15/2010.

See if this does what you want:

A1 = birth date

=DATEDIF(A1,TODAY(),"m")

See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP


"Meg" <(E-Mail Removed)> wrote in message
news:6FAFB5CE-9201-45EC-9E3C-(E-Mail Removed)...
> Hi - I would like to calculate a child's age into months. For example, if
> a
> child is 1 year old, the cell would read '12' months old.
>
> What's more important, I don't want to round up to the nearest month. So,
> if a child turned 12months on 12/15/09 (born 12/15/08) and today is
> 1/6/2010,
> I would like it to round down to 24months.
>
> It would only turn 25months if today was 1/15/2010.
>
> Regards, Meg

This is great, thank you very much!

Meg

"Jim Thomlinson" wrote:

> Use the datedif function something like this...
>
> =DATEDIF(A1, TODAY(), "m")
>
> Here is a link on using datedif
> http://www.cpearson.com/excel/datedif.aspx
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Meg" wrote:
>
> > Hi - I would like to calculate a child's age into months. For example, if a
> > child is 1 year old, the cell would read '12' months old.
> >
> > What's more important, I don't want to round up to the nearest month. So,
> > if a child turned 12months on 12/15/09 (born 12/15/08) and today is 1/6/2010,
> > I would like it to round down to 24months.
> >
> > It would only turn 25months if today was 1/15/2010.
> >
> > Regards, Meg