| 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) | |||
Hybrid Mode
