Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d.
I tried to callculate the difference between 14.02.1980 and 21.02.1985, but
excel does not give the exact difference in years, months and days. I used the formula =DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months, "&DATEDIF(A10,B10,"MD")&"Days." |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d.
When I copied your formula from the screen and pasted it into Excel, it
returned: 5Years, 0Months, 7Days. That value is correct. You don't mention what value is returned by the formula you used. *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: I tried to callculate the difference between 14.02.1980 and 21.02.1985, but excel does not give the exact difference in years, months and days. I used the formula =DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months, "&DATEDIF(A10,B10,"MD")&"Days." |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d
Thanks for the feedback, try the formula on 14.02.1980 to 01.04.1995, the
result is 15 years, 1 month, 18 days whereas actual difference is 15 years, 1 month, 17 days. "Ron Coderre" wrote: When I copied your formula from the screen and pasted it into Excel, it returned: 5Years, 0Months, 7Days. That value is correct. You don't mention what value is returned by the formula you used. *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: I tried to callculate the difference between 14.02.1980 and 21.02.1985, but excel does not give the exact difference in years, months and days. I used the formula =DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months, "&DATEDIF(A10,B10,"MD")&"Days." |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d
OK....see if this makes sense
With 14.02.1980 to 01/04.1995 Feb-14-1980 to Feb-14-1995: 1 year Feb-14-1995 to Mar-14-1995: 1 month Mar-14-1995 to Apr-01-1995: 18 days Does that help? *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: Thanks for the feedback, try the formula on 14.02.1980 to 01.04.1995, the result is 15 years, 1 month, 18 days whereas actual difference is 15 years, 1 month, 17 days. "Ron Coderre" wrote: When I copied your formula from the screen and pasted it into Excel, it returned: 5Years, 0Months, 7Days. That value is correct. You don't mention what value is returned by the formula you used. *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: I tried to callculate the difference between 14.02.1980 and 21.02.1985, but excel does not give the exact difference in years, months and days. I used the formula =DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months, "&DATEDIF(A10,B10,"MD")&"Days." |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d
Thanks, yes it has sense and now I understand how Excel calculates the
difference in dates which seems the correct way. I have another problem, please help me on that if you or anybody else can. I need to convert amount written in one cell in figures ($20500) in words in the next cell or any other cell (Dollar Twenty Thousand Five Hundred Only). Is there any formula in Excell for that. Regards, Muhammad Javaid Hassan "Muhammad Javaid Hassan" wrote: Thanks for the feedback, try the formula on 14.02.1980 to 01.04.1995, the result is 15 years, 1 month, 18 days whereas actual difference is 15 years, 1 month, 17 days. "Ron Coderre" wrote: When I copied your formula from the screen and pasted it into Excel, it returned: 5Years, 0Months, 7Days. That value is correct. You don't mention what value is returned by the formula you used. *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: I tried to callculate the difference between 14.02.1980 and 21.02.1985, but excel does not give the exact difference in years, months and days. I used the formula =DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months, "&DATEDIF(A10,B10,"MD")&"Days." |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d
Muhammad Javaid Hassan wrote: I need to convert amount written in one cell in figures ($20500) in words in the next cell or any other cell (Dollar Twenty Thousand Five Hundred Only). Is there any formula in Excell for that. Regards, Muhammad Javaid Hassan Spell out the number as follows using this add-in. http://orlando.mvps.org/ExcelSpellNumberMore.asp Pierre |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d
Thanks, I think it make sense. Actually it is the way Excel works out the
difference in two dates and seems the correct way. I have another problem, please you or anyone help me on this if possible. I am trying to convert amount written in one cell in figures ($20560) to amount in words in the next or any other cell (Dollar Twenty Thousand Five Hundred Sixty Only). Can it be done in Excel? Regards, Muhammad Javaid Hassan "Ron Coderre" wrote: OK....see if this makes sense With 14.02.1980 to 01/04.1995 Feb-14-1980 to Feb-14-1995: 1 year Feb-14-1995 to Mar-14-1995: 1 month Mar-14-1995 to Apr-01-1995: 18 days Does that help? *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: Thanks for the feedback, try the formula on 14.02.1980 to 01.04.1995, the result is 15 years, 1 month, 18 days whereas actual difference is 15 years, 1 month, 17 days. "Ron Coderre" wrote: When I copied your formula from the screen and pasted it into Excel, it returned: 5Years, 0Months, 7Days. That value is correct. You don't mention what value is returned by the formula you used. *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: I tried to callculate the difference between 14.02.1980 and 21.02.1985, but excel does not give the exact difference in years, months and days. I used the formula =DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months, "&DATEDIF(A10,B10,"MD")&"Days." |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d
Here's the resource you need:
http://www.xldynamic.com/source/xld.xlFAQ0004.html Does that help? *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: Thanks, yes it has sense and now I understand how Excel calculates the difference in dates which seems the correct way. I have another problem, please help me on that if you or anybody else can. I need to convert amount written in one cell in figures ($20500) in words in the next cell or any other cell (Dollar Twenty Thousand Five Hundred Only). Is there any formula in Excell for that. Regards, Muhammad Javaid Hassan "Muhammad Javaid Hassan" wrote: Thanks for the feedback, try the formula on 14.02.1980 to 01.04.1995, the result is 15 years, 1 month, 18 days whereas actual difference is 15 years, 1 month, 17 days. "Ron Coderre" wrote: When I copied your formula from the screen and pasted it into Excel, it returned: 5Years, 0Months, 7Days. That value is correct. You don't mention what value is returned by the formula you used. *********** Regards, Ron XL2002, WinXP "Muhammad Javaid Hassan" wrote: I tried to callculate the difference between 14.02.1980 and 21.02.1985, but excel does not give the exact difference in years, months and days. I used the formula =DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months, "&DATEDIF(A10,B10,"MD")&"Days." |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate exact difference between two dates in y,m,d
Thanks Pierre!, it realy works.
Regards, Muhammad Javaid Hassan "Pierre" wrote: Muhammad Javaid Hassan wrote: I need to convert amount written in one cell in figures ($20500) in words in the next cell or any other cell (Dollar Twenty Thousand Five Hundred Only). Is there any formula in Excell for that. Regards, Muhammad Javaid Hassan Spell out the number as follows using this add-in. http://orlando.mvps.org/ExcelSpellNumberMore.asp Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to obtain difference between two dates. | Excel Worksheet Functions | |||
difference between dates | Excel Discussion (Misc queries) | |||
Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions | |||
calculate with dates before 1-1-1900 | Excel Worksheet Functions |