Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compute the difference between two dates accurately
Date360 gives an inacurate answer that over the course of 20 years can be
over a month. Is there an accurate way of computing the difference between two dates? |
#2
|
|||
|
|||
how about simply subtracting one from another
=B1-A1 where B1 holds the end date and cell A1 the start date Why days360 unless you want to use 360 days per year convention. "Dilly" wrote in message ... Date360 gives an inacurate answer that over the course of 20 years can be over a month. Is there an accurate way of computing the difference between two dates? |
#3
|
|||
|
|||
=A1-B1
where A1 holds the later date and B1 the earlier date, format as general DATE260 is an accounting function Regards, Peo Sjoblom "Dilly" wrote: Date360 gives an inacurate answer that over the course of 20 years can be over a month. Is there an accurate way of computing the difference between two dates? |
#4
|
|||
|
|||
Dilly
See Chip Pearson's site for info on the DATEDIF Function. http://www.cpearson.com/excel/datedif.htm Gord Dibben Excel MVP On Fri, 29 Apr 2005 12:46:04 -0700, "Dilly" wrote: Date360 gives an inacurate answer that over the course of 20 years can be over a month. Is there an accurate way of computing the difference between two dates? |
#5
|
|||
|
|||
Thanks but I tried that. for example: 2004/05/30 - 1986/06/24 returns
1917/12/06. actual answer should be 1917/11/06. it doesn't recognize zero month. "N Harkawat" wrote: how about simply subtracting one from another =B1-A1 where B1 holds the end date and cell A1 the start date Why days360 unless you want to use 360 days per year convention. "Dilly" wrote in message ... Date360 gives an inacurate answer that over the course of 20 years can be over a month. Is there an accurate way of computing the difference between two dates? |
#6
|
|||
|
|||
If you just wanted the number of days, try formatting that cell as general.
Dilly wrote: Thanks but I tried that. for example: 2004/05/30 - 1986/06/24 returns 1917/12/06. actual answer should be 1917/11/06. it doesn't recognize zero month. "N Harkawat" wrote: how about simply subtracting one from another =B1-A1 where B1 holds the end date and cell A1 the start date Why days360 unless you want to use 360 days per year convention. "Dilly" wrote in message ... Date360 gives an inacurate answer that over the course of 20 years can be over a month. Is there an accurate way of computing the difference between two dates? -- Dave Peterson |
#7
|
|||
|
|||
Thanks, but I need it in yy/mm/dd format. see gord dibben's answer below.
"Dave Peterson" wrote: If you just wanted the number of days, try formatting that cell as general. Dilly wrote: Thanks but I tried that. for example: 2004/05/30 - 1986/06/24 returns 1917/12/06. actual answer should be 1917/11/06. it doesn't recognize zero month. "N Harkawat" wrote: how about simply subtracting one from another =B1-A1 where B1 holds the end date and cell A1 the start date Why days360 unless you want to use 360 days per year convention. "Dilly" wrote in message ... Date360 gives an inacurate answer that over the course of 20 years can be over a month. Is there an accurate way of computing the difference between two dates? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85. | Excel Worksheet Functions | |||
Calculate difference between two dates | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions |