Maths formula to count days between two dates
Answers
Answered by
0
working on getting date difference I have a formula to calculate it as follows
365⋅year+year4−year100+year400+date+153⋅month+85365⋅year+year4−year100+year400+date+153⋅month+85
but its not working on leap years like
if dates are 1-1-2012 and 1-1-2013 the difference should be 366 days but its giving 365.
365⋅year+year4−year100+year400+date+153⋅month+85365⋅year+year4−year100+year400+date+153⋅month+85
but its not working on leap years like
if dates are 1-1-2012 and 1-1-2013 the difference should be 366 days but its giving 365.
Similar questions