Related:
- Number of Days between 2 dates
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Resident evil 2 remake download - Download - Horror
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 2, 2010 at 11:22 AM
Jul 2, 2010 at 11:22 AM
Duplicate ?
Netscur
Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012
Jul 2, 2010 at 02:10 PM
Jul 2, 2010 at 02:10 PM
Requests should specify the date format they are using. In the above example I believe they listed the format as: DD/MM/YYYY. So if I understand correctly, the example is subtracting August 9, 1965 from February 5th, 2007 getting a result of 15155 days.
All that taken into account, I think the reason you are seeing a delta in results is the fact the calendar contains Leap year. Excel compensates for a leap year (additional days) where as your calculation resulting in 15146 does not appear to.
Perhaps this piece of information will lead you or someone else in the right direction or provide you a better answer.
Additionally, if you want to view your result as "Years, months, and days", try this formula (where your first date is in A1, and your second date is in A2).
=YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1),
DAY(A2)<DAY(A1))),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AND(MONTH(A2)
<=MONTH(A1),DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<MONTH(A1),DAY(A2)
>=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A2)<DAY(A1)),-1)))&" months,
"&A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&" days"
-Netscur
All that taken into account, I think the reason you are seeing a delta in results is the fact the calendar contains Leap year. Excel compensates for a leap year (additional days) where as your calculation resulting in 15146 does not appear to.
Perhaps this piece of information will lead you or someone else in the right direction or provide you a better answer.
Additionally, if you want to view your result as "Years, months, and days", try this formula (where your first date is in A1, and your second date is in A2).
=YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1),
DAY(A2)<DAY(A1))),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AND(MONTH(A2)
<=MONTH(A1),DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<MONTH(A1),DAY(A2)
>=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A2)<DAY(A1)),-1)))&" months,
"&A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&" days"
-Netscur
