Page 1 of 1
date
Posted: Sat Jul 02, 2016 7:40 pm
by rathanak
Hi any one knows how to calculate difference between 2 dates prior to 1900 for eg difference between - 15/10/1888 to 22/06/2016
Re: date
Posted: Sat Jul 02, 2016 7:54 pm
by snasui
Go to Excel Options (File > Options or Alt+F, T) and set date to 1904 date system. See picture below.
Re: date
Posted: Sun Jul 03, 2016 12:43 pm
by ratanak
After that can we use datedif to do calculation?
Re: date
Posted: Sun Jul 03, 2016 12:45 pm
by snasui
Yes, You can use all functions that can calculate numeric.
Re: date
Posted: Sun Jul 03, 2016 1:09 pm
by ratanak
Please provide formula
Re: date
Posted: Sun Jul 03, 2016 1:28 pm
by snasui
Please attatch file and enter your correct result.
Re: date
Posted: Sun Jul 03, 2016 1:45 pm
by ratanak
i.e 15/10/1888 to 22/06/2016
Re: date
Posted: Sun Jul 03, 2016 1:51 pm
by snasui
Assumming your data in A1:B1.
C1 Enter this formula.
=B1-A1
Re: date
Posted: Sun Jul 03, 2016 2:05 pm
by ratanak
If i want years ,months and days between these two dates?
Re: date
Posted: Sun Jul 03, 2016 2:20 pm
by snasui
I don't know your exact result value. Please tell me each correct results.
You can devide with 365 for year, devide with 12 for month and again please attach file.
Re: date
Posted: Sun Jul 03, 2016 6:13 pm
by rathanak
Can this output is possible in one cell like 128 year 8 month & 7 days?
Re: date
Posted: Sun Jul 03, 2016 8:02 pm
by snasui
Set Excel option to default, then try this,
=DATEDIF(LEFT(A2,6)&RIGHT(A2,4)+2000,LEFT(B2,6)&RIGHT(B2,4)+2000,"y")&" Years "&DATEDIF(LEFT(A2,6)&RIGHT(A2,4)+2000,LEFT(B2,6)&RIGHT(B2,4)+2000,"ym")&" Months "&DATEDIF(LEFT(A2,6)&RIGHT(A2,4)+2000,LEFT(B2,6)&RIGHT(B2,4)+2000,"md")& " Days"
!
| Note: Enter date with text format, dd/mm/yyyy (10 digits) |
Re: date
Posted: Mon Jul 04, 2016 8:56 am
by rathanak
It is still not working
Re: date
Posted: Mon Jul 04, 2016 9:29 am
by logic
Why not attach file?
Re: date
Posted: Mon Jul 04, 2016 11:51 am
by ratanak