Finding number of days between two dates

[ADITYA]

Dear All,


Is there any correct formula to find the number of days between two days.


I used to have formula like =Days 360( 1-Apr-12,30-Mar-13)+5. Some times its giving wrong.

Earlier i used to use (= 1-Apr-12-30-Mar-13), but it proved be a wrong.


Any help in this regard would be highly appreciated.

 

[ThrottleWorks]

Hi Aditya,


meanwhile someone helps you with the solution, could you please check the below links.


Might be usedful.


http://chandoo.org/forums/topic/how-to-calculate-difference-between-dates


http://chandoo.org/forums/topic/no-of-days-between-two-date-in-ms-excel-2003

 

[sudipto3003]

dear ADITYA


if u r looking for the number of days between to dates simple use it.


=(current date-earlier date)+1


regards

sda

 

[ADITYA]

Thanks for your reply.


If i use current date (current date-earlier date)+1, I am getting difference for example if i want to calculate interest on 31 Mar'13 it will come as ( 31/Mar/13-31/Mar/31)+1=1 1.e (current date-earlier date)+1 .

In above case formula would be wrong. Any help please.


Regards

 

[NARAYANK991]

Hi Aditya ,


If we take the example that you have given , when the two dates are the same , what should the difference be ?


Narayan

 

[sudipto3003]

hi aditya,


you can use this one....

=DATEDIF(A1,A2,"d")

where A1 cell refers the start day and A2 cell refers the end day and also if you wish change the "d" to "m" to find out the result in months.


regards

sda

 

[SirJB7]

Hi, ADITYA!

Regarding the suggested function DATEDIF it'd be better if your read this:

http://chandoo.org/forums/topic/calculation-of-of-months-between-end-of-year-and-a-given-inputted-date#post-17696

Regards!

 

[ADITYA]

Thanks all of you for all of your efforts.