Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Return total number of YEARS & MONTHS in a cell

Hi guys...

Using Excel 2003 - I found in the help how to return the number of YEARS
between 2 dayes and how many MONTHS.. but not both together...MY goal is the
output to a cell how many Years and Months have passed from TODAY
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 347
Default Return total number of YEARS & MONTHS in a cell

Hi,

Try something like this:

=DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&" months"

Regards!
Jean-Guy

"Montrose guy" wrote:

Hi guys...

Using Excel 2003 - I found in the help how to return the number of YEARS
between 2 dayes and how many MONTHS.. but not both together...MY goal is the
output to a cell how many Years and Months have passed from TODAY

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Return total number of YEARS & MONTHS in a cell

If A1 contains a date then

=DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months,
" & DATEDIF(A1,TODAY(),"md") & " days"

for example, in A1:
1/15/1985

the formula returns:
20 years, 11 months, 16 days


--
Gary''s Student - gsnu200757


"Montrose guy" wrote:

Hi guys...

Using Excel 2003 - I found in the help how to return the number of YEARS
between 2 dayes and how many MONTHS.. but not both together...MY goal is the
output to a cell how many Years and Months have passed from TODAY

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Return total number of YEARS & MONTHS in a cell

Take a look he

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

for an explanation and examples of how to use the DATEDIF function -
this is not included in Excel Help for 2003, although it is a standard
function.

Hope this helps.

Pete

On Nov 18, 12:58 pm, Montrose guy
wrote:
Hi guys...

Using Excel 2003 - I found in the help how to return the number of YEARS
between 2 dayes and how many MONTHS.. but not both together...MY goal is the
output to a cell how many Years and Months have passed from TODAY


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
Number of years/months/days between 2 dates Deborah Excel Worksheet Functions 4 July 7th 06 11:24 AM
how do I convert a number to number of years, months and days because Excel Worksheet Functions 2 October 12th 05 06:15 PM
Number of years, months, days between two dates. Bluenose Excel Worksheet Functions 34 June 30th 05 02:18 PM
Converting number of days to years and months Dave Cobb Excel Worksheet Functions 4 May 24th 05 09:14 PM


All times are GMT +1. The time now is 12:06 AM.

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"