Re: $$Excel-Macros$$ Please help regard this question

2010-11-15 Thread Srinivasan Ethirajalu
=IF(A1 >= A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)& " Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & DAY(A1) - DAY(A2) & " Day(s) Left", "Please check the date(s)") On Mon, Nov 15, 2010 at 11:14 AM, Manjunath C wrote: > Excellent one,,,its working,,

Re: $$Excel-Macros$$ Please help regard this question

2010-11-14 Thread Manjunath C
Excellent one,,,its working Is it possbile , the result should be 0 , if i give same dates for both. On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > =IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & > IF(MONTH(A1) - MO

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread Srinivasan Ethirajalu
=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check the date(s)") this will supress if year/month/day = 0 in the expansio

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread Srinivasan Ethirajalu
=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") & IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") & IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check the date(s)") On Fri, Nov 12, 2010 at 4:19 PM, Jai wrote: > THANKS A LO

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread Jai
THANKS A LOST EXPERTS On Fri, Nov 12, 2010 at 3:59 PM, SAJID MANSOOR wrote: > Very simple! Good > > > On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI > wrote: > >> Dear Jai... >> >> Please see attachment.. >> >> =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, >> "&TEXT((D5-D6),"dd")&

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread SAJID MANSOOR
Very simple! Good On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI wrote: > Dear Jai... > > Please see attachment.. > > =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, > "&TEXT((D5-D6),"dd")&" DAYS" > Thanks, > Noorain > On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote: > >> Dear Groups >

Re: $$Excel-Macros$$ Please help regard this question

2010-11-11 Thread NOORAIN ANSARI
Dear Jai... Please see attachment.. =TEXT(D5-D6,"YY ")&"YEAR, "&TEXT((D5-D6),"mm")&" MONTH, "&TEXT((D5-D6),"dd")&" DAYS" Thanks, Noorain On Thu, Nov 11, 2010 at 9:47 PM, Jai wrote: > Dear Groups > > First Cell > > 20/12/2011 > > Secound Cell > > 12/11/2010 > > R

Re: $$Excel-Macros$$ Please help regard this question

2010-11-11 Thread Aindril De
Hey Jai, Supposing the dates are in cells A1 and A2, you can use the following in cell A3: =DATEDIF(A2,A1,"y")&IF(DATEDIF(A2,A1,"y")>1," years ,"," year ,")&DATEDIF(A2,A1,"ym")&IF(DATEDIF(A2,A1,"ym")>1," months ,"," month ,")&DATEDIF(A2,A1,"md")&IF(DATEDIF(A2,A1,"md")>1," days left."," day left."