| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate diiference between 2 dates
I have 2 dates and I want to calculate the difference expressed as the
following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate diiference between 2 dates
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days" should do the trick with the dates in A1 & A2 Mike "Jester" wrote: I have 2 dates and I want to calculate the difference expressed as the following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate diiference between 2 dates
Hi John,
=DATEDIF(A1,A2,"y") & " Years " & DATEDIF(A1,A2,"ym") & " months and " & DATEDIF(A1,A2,"md") & " days" For info about the DATEDIF function, look he http://www.cpearson.com/excel/datedif.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Jester" wrote in message ... |I have 2 dates and I want to calculate the difference expressed as the | following string: | | (eg) 9 Years 3 months and 13 days | | Can anyone help? | | Many Thanks | | John - Sydney Aust | | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate diiference between 2 dates
Thankyou very much!!!
"Mike" wrote in message ... =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " & DATEDIF(A1,A2,"md") & " days" should do the trick with the dates in A1 & A2 Mike "Jester" wrote: I have 2 dates and I want to calculate the difference expressed as the following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate diiference between 2 dates
Thankyou very much!!!!
"Niek Otten" wrote in message ... Hi John, =DATEDIF(A1,A2,"y") & " Years " & DATEDIF(A1,A2,"ym") & " months and " & DATEDIF(A1,A2,"md") & " days" For info about the DATEDIF function, look he http://www.cpearson.com/excel/datedif.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "Jester" wrote in message ... |I have 2 dates and I want to calculate the difference expressed as the | following string: | | (eg) 9 Years 3 months and 13 days | | Can anyone help? | | Many Thanks | | John - Sydney Aust | | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate diiference between 2 dates
I've run a quick check on this formula. It doesn't seem to include
additional leap year days. Regards. Bill Ridgeway Computer Solutions "Mike" wrote in message ... =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " & DATEDIF(A1,A2,"md") & " days" should do the trick with the dates in A1 & A2 Mike "Jester" wrote: I have 2 dates and I want to calculate the difference expressed as the following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate diiference between 2 dates
On reflection I suppose it wouldn't - and rightfully so. The possible
danger in calculating using year and month is that they are not a standard length. Days on the other hand is a much more precise measure. There is one perennial trap when calculating the period between two dates. The answer lies in whether or not you are counting gross or net days. In a situation of, say, the payment of a pension due in a year, the number of days in payment is 365 (366). In a situation of, the number of days available to do something, the number of days is 364 (365). Regards. Bill Ridgeway Computer Solutions "Bill Ridgeway" wrote in message ... I've run a quick check on this formula. It doesn't seem to include additional leap year days. Regards. Bill Ridgeway Computer Solutions "Mike" wrote in message ... =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " & DATEDIF(A1,A2,"md") & " days" should do the trick with the dates in A1 & A2 Mike "Jester" wrote: I have 2 dates and I want to calculate the difference expressed as the following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate diiference between 2 dates
Chhers Bill , in my case I am more than happy with what the formula does.
It meets my needs precisely John "Bill Ridgeway" wrote in message ... On reflection I suppose it wouldn't - and rightfully so. The possible danger in calculating using year and month is that they are not a standard length. Days on the other hand is a much more precise measure. There is one perennial trap when calculating the period between two dates. The answer lies in whether or not you are counting gross or net days. In a situation of, say, the payment of a pension due in a year, the number of days in payment is 365 (366). In a situation of, the number of days available to do something, the number of days is 364 (365). Regards. Bill Ridgeway Computer Solutions "Bill Ridgeway" wrote in message ... I've run a quick check on this formula. It doesn't seem to include additional leap year days. Regards. Bill Ridgeway Computer Solutions "Mike" wrote in message ... =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " & DATEDIF(A1,A2,"md") & " days" should do the trick with the dates in A1 & A2 Mike "Jester" wrote: I have 2 dates and I want to calculate the difference expressed as the following string: (eg) 9 Years 3 months and 13 days Can anyone help? Many Thanks John - Sydney Aust |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate dates | Excel Worksheet Functions | |||
| calculate dates | Excel Discussion (Misc queries) | |||
| How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions | |||
| How do I calculate an age from 2 dates? | Excel Worksheet Functions | |||
| How do I calculate dates? | Excel Worksheet Functions | |||
Linear Mode
