Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to calculate years, months by using one formula
i would like to know to how to calculate year,month and date between to dates
Example 01/10/1977 and 10/04/2002 . i want to know the formula for getting correct years, months and days between above dates |
#2
|
|||
|
|||
Use the undocumented function DATEDIF
See Chips site for details www.cpearson.com best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "srinivasa rao" <srinivasa wrote in message ... i would like to know to how to calculate year,month and date between to dates Example 01/10/1977 and 10/04/2002 . i want to know the formula for getting correct years, months and days between above dates |
#3
|
|||
|
|||
This site will also show how to calculate the difference between years,
months, and days: http://www.pdbook.com/index.php/excel/date_differences/ ---- Regards, John Mansfield http://www.pdbook.com "srinivasa rao" wrote: i would like to know to how to calculate year,month and date between to dates Example 01/10/1977 and 10/04/2002 . i want to know the formula for getting correct years, months and days between above dates |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate date differences in years and months | Excel Worksheet Functions | |||
How do I calculate total of months that have passed? | Excel Discussion (Misc queries) | |||
Converting months to years | Excel Worksheet Functions | |||
Calculate months and years | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |