Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number of days into years/months | Excel Discussion (Misc queries) | |||
Number of years/months/days between 2 dates | Excel Worksheet Functions | |||
how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
Number of years, months, days between two dates. | Excel Worksheet Functions | |||
Converting number of days to years and months | Excel Worksheet Functions |