Date Difference in Execl 2

[dipgohil79]

Hi to all,
In MS Excel there is a function Call Days360, which gives the difference bitween two dates.but the problem is it count year as 360 days. I want the real calculation that is 365 for normal year and 366 for leapyear.
I am very new in VBA. so i need help for this.

 

[AnotherHiggins]

Dates are stored as integers. So all you need is End Date - Start Date

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[dipgohil79]

@anotherhiggins
thanks for quick response. but while testing when i use following this two dates 1-Nov-08 and 12-Nov-08 some time i got result 11 and some time i got result 11-Jan-00.

I am confuse about this.

 

[TonyJollans]

[blue][tt]11[/tt][/blue] and [blue][tt]11-Jan-00[/tt][/blue] are just different ways of formatting the same underlying value. Format your result cell as a number - instead of as a date - and you will get [blue][tt]11[/tt][/blue].

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[HughLerwill]

If you remove the date format on the cells containing the dates and impose number format you will see 01/11/2008 change into 39753 and 12/11/2008 change into 38764; these numbers represent the number of days since 31 Dec 1899 which Excel uses as a reference.
When you subtract the dates Excel computes the difference between the two 'day numbers' and gives you 11 however it is in appropriate to apply a date format to this result because the format will only return a date equal to eleven days after 31 Dec 1899. If you require a result formatted in years, months, days you will have to do that yourself.

 

[dipgohil79]

Thanks "TonyJollans" and "anotherhiggins" for your respons.

you people are great, just do what you are doing - helping the others

 

[SkipVought]

faq68-5827

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}