A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Convert Age to Months



 
 
Thread Tools Display Modes
  #1  
Old January 6th 10, 08:27 PM posted to microsoft.public.excel.misc
Meg
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
Ads
  #2  
Old January 6th 10, 08:39 PM posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
 
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  
Old January 6th 10, 08:53 PM posted to microsoft.public.excel.misc
T. Valko
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  
Old January 6th 10, 08:54 PM posted to microsoft.public.excel.misc
Meg
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 06:06 AM
convert # of years, months and days catrrmg Excel Discussion (Misc queries) 4 February 1st 08 04: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 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 10:54 PM.


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