Remember Me?

#1
January 6th 10, 07:27 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 22
Convert Age to Months

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

#2
January 6th 10, 07:39 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 5,942
Convert Age to Months

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

#3
January 6th 10, 07:53 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
Convert Age to Months

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

#4
January 6th 10, 07:54 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 22
Convert Age to Months

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jon Excel Discussion (Misc queries) 4 November 12th 14 05:06 AM catrrmg Excel Discussion (Misc queries) 4 February 1st 08 03:42 PM eileenmole Excel Discussion (Misc queries) 1 September 6th 07 08:32 PM doctor who golf New Users to Excel 3 October 30th 06 11:12 PM SDPMIAMI Excel Worksheet Functions 1 June 17th 05 03:56 AM

All times are GMT +1. The time now is 07:57 PM.