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
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
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 [email protected]> wrote in message
news:[email protected]...
>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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks