Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meg Meg is offline
external usenet poster
 
Posts: 22
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Meg Meg is offline
external usenet poster
 
Posts: 22
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert number of days into years/months eileenmole Excel Discussion (Misc queries) 2 April 17th 23 07:00 PM
how to convert number of days to months Jon Excel Discussion (Misc queries) 4 November 12th 14 06:06 AM
convert # of years, months and days catrrmg Excel Discussion (Misc queries) 4 February 1st 08 04:42 PM
how to convert 12/10/1970 to years/months/days doctor who golf New Users to Excel 3 October 31st 06 12:12 AM
How do i convert years to months (formula) SDPMIAMI Excel Worksheet Functions 1 June 17th 05 03:56 AM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"