Re: $$Excel-Macros$$ date difference problem

2013-07-30 Thread Shankar Bheema
thank u deepak its working On Sat, Jul 27, 2013 at 12:09 AM, Deepak Barnwal wrote: > PFA > > Regards > > deepak > > > On Fri, Jul 26, 2013 at 11:28 PM, vba wrote: > >> PFA >> >> Actually years should be 37 & not 36!! >> >> HTH//Cheers >> >> >> On Fri, Jul 26, 2013 at 10:12 AM, Shankar Bheema >>

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
End Sub > > *From:* dguillett1 > *Sent:* Monday, September 12, 2011 1:04 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ date difference > > I am an advocate of the KISS (keep it simple stupid-not meant > personally) so stick with my original offe

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread dguillett1
difference I am an advocate of the KISS (keep it simple stupid-not meant personally) so stick with my original offering. From: Shankar Bheema Sent: Monday, September 12, 2011 10:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ date difference but i am using userform na sir

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread dguillett1
I am an advocate of the KISS (keep it simple stupid-not meant personally) so stick with my original offering. From: Shankar Bheema Sent: Monday, September 12, 2011 10:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ date difference but i am using userform na sir. So pls

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
>>> End Sub >>>>> >>>>> Regards, >>>>> >>>>> Sam Mathai Chacko (GL) >>>>> >>>>> >>>>> On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema < >>>>> shankar.n...@gmail.com> wrote: >>>

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
gt;> On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 wrote: >>> >>>> Why not just a simple formula for a dob in cell d11 >>>> >>>> =DATE(YEAR(D11)+60,MONTH(D11)+1,0) >>>> >>>> *From:* Shankar Bheema >>>> *Sent:*

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
11 at 9:28 PM, Shankar Bheema >>> > wrote: >>>> >>>>> but i am using userform na sir. So pls see my attachment and i am not >>>>> understanding the mistake i did in my code >>>>> >>>>> >>>>>

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
ke i did in my code >>>> >>>> >>>> On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 wrote: >>>> >>>>> Why not just a simple formula for a dob in cell d11 >>>>> >>>>> =DATE(YEAR(D11)+60,MONTH(D11)+1,0) >>&

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
gt;> understanding the mistake i did in my code >> >> >> On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 wrote: >> >>> Why not just a simple formula for a dob in cell d11 >>> >>> =DATE(YEAR(D11)+60,MONTH(D11)+1,0) >>> >>> *Fro

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
1)+1,0) >> >> *From:* Shankar Bheema >> *Sent:* Monday, September 12, 2011 9:54 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ date difference >> >> Hai all, >> >> I am attaching an excel userform which contains Dateof B

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
Shankar Bheema > *Sent:* Monday, September 12, 2011 9:54 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ date difference > > Hai all, > > I am attaching an excel userform which contains Dateof Birth textbox and > Date of Retirement textbox. > > Condit

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread dguillett1
Why not just a simple formula for a dob in cell d11 =DATE(YEAR(D11)+60,MONTH(D11)+1,0) From: Shankar Bheema Sent: Monday, September 12, 2011 9:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ date difference Hai all, I am attaching an excel userform which

$$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
Hai all, I am attaching an excel userform which contains Dateof Birth textbox and Date of Retirement textbox. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth is in the year 1960 date of retirement would be 2020 ii) Date of retirement would be la

Re: $$Excel-Macros$$ Date Difference

2011-07-01 Thread Chandra Shekar
Thanks a lot :-) On Fri, Jul 1, 2011 at 6:06 PM, ashish koul wrote: > try the attachment > > > On Fri, Jul 1, 2011 at 3:50 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hi, >> >> I need a formula which need to ignore weekends. Thanks >> >> For Ex: >> >> A1=01/07/2011 - Input >

RE: $$Excel-Macros$$ Date Difference

2011-07-01 Thread Daniel
2011 12:21 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Date Difference Hi, I need a formula which need to ignore weekends. Thanks For Ex: A1=01/07/2011 - Input B1=30/06/2011 - Result1 C1=04/07/2011 - Result2 ' 02/07/2011 & 03/07/2011 are saturdays an

Re: $$Excel-Macros$$ Date Difference

2011-07-01 Thread ashish koul
try the attachment On Fri, Jul 1, 2011 at 3:50 PM, Chandra Shekar wrote: > Hi, > > I need a formula which need to ignore weekends. Thanks > > For Ex: > > A1=01/07/2011 - Input > B1=30/06/2011 - Result1 > C1=04/07/2011 - Result2 ' 02/07/2011 & 03/07/2011 are saturdays and > sundays. > > -- > > --

$$Excel-Macros$$ Date Difference

2011-07-01 Thread Chandra Shekar
Hi, I need a formula which need to ignore weekends. Thanks For Ex: A1=01/07/2011 - Input B1=30/06/2011 - Result1 C1=04/07/2011 - Result2 ' 02/07/2011 & 03/07/2011 are saturdays and sundays. -- -- Some important lin