Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 6th 10, 07:27 PM posted to microsoft.public.excel.misc
Meg Meg is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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  
Old 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
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  
Old 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
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  
Old January 6th 10, 07:54 PM posted to microsoft.public.excel.misc
Meg Meg is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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
how to convert number of days to months Jon Excel Discussion (Misc queries) 4 November 12th 14 05:06 AM
convert # of years, months and days catrrmg Excel Discussion (Misc queries) 4 February 1st 08 03:42 PM
convert number of days into years/months eileenmole Excel Discussion (Misc queries) 1 September 6th 07 08:32 PM
how to convert 12/10/1970 to years/months/days doctor who golf New Users to Excel 3 October 30th 06 11:12 PM
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 07:57 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017