| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate years between two dates more precisely
How do I set up a formula so I would get this answer:
01.01.2003 - 02.01.2001 = 1 year (not 2 because of the second date) Jørn Johansen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate years between two dates more precisely
=DATEDIF("02/01/2001","01/01/2003","y")
Further details are he http://www.cpearson.com/excel/datedif.htm Regards Geoff "Jørn Johansen" wrote in message ... How do I set up a formula so I would get this answer: 01.01.2003 - 02.01.2001 = 1 year (not 2 because of the second date) Jørn Johansen |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate years between two dates more precisely
On Thu, 30 Oct 2003 21:56:04 +0100, "Jørn Johansen" wrote:
How do I set up a formula so I would get this answer: 01.01.2003 - 02.01.2001 = 1 year (not 2 because of the second date) Jørn Johansen Look at the undocumented DATEDIFF function: =DATEDIF("2/1/2001","1/1/2003","y") -- 1 See http://www.cpearson.com/excel.htm --ron |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate years between two dates more precisely
Thanks. I have tried, but it does not give an answer at all! I use Excel
2002, norwegian language. "GB" skrev i melding ... =DATEDIF("02/01/2001","01/01/2003","y") Further details are he http://www.cpearson.com/excel/datedif.htm Regards Geoff "Jørn Johansen" wrote in message ... How do I set up a formula so I would get this answer: 01.01.2003 - 02.01.2001 = 1 year (not 2 because of the second date) Jørn Johansen |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate years between two dates more precisely
Here's a macro by Harald Staff which might help you translate:
http://google.com/groups?threadm=865...o-nntp.eunet.n o (Watch linewrap - the URL ends in .no) In article , "Jørn Johansen" wrote: Thanks. I have tried, but it does not give an answer at all! I use Excel 2002, norwegian language. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I calculate a difference in dates in years and months? | Excel Discussion (Misc queries) | |||
| how do I calculate years between two dates | Excel Discussion (Misc queries) | |||
| How do I calculate the number of years between 2 dates | Excel Discussion (Misc queries) | |||
| HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES | Excel Worksheet Functions | |||
| Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
Linear Mode
