$$Excel-Macros$$ Re: Please unsuscribe

Please unsubscribe On Wed, Jan 2, 2013 at 10:25 AM, Praveen Golash wrote: > Please do the needful. > > -- > Regards, > > Praveen Golash > > -- Regards, Praveen Golash KPMG Advisory Services Pvt. Ltd. Mobile: +91- 9711302259 -- Join official Facebook pag

$$Excel-Macros$$ Please unsuscribe

Please do the needful. -- Regards, Praveen Golash -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

$$Excel-Macros$$ Re: HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO DATES

Hi Ajit, a) convert both the number in date format... b) Substract the dates and divide by 365/366 as the case be. I hope that solves your problem. On 9/22/08, AJIT NAVRE <[EMAIL PROTECTED]> wrote: > > Use the formula, > > > =IF(A1>DATE(2004,3,31),0,IF(YEAR(DATE(2004,3,31))-YEAR(A1)=0,1,YEAR