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

2013-07-31 Thread Shankar Bheema
thank u deepak its working On Sat, Jul 27, 2013 at 12:09 AM, Deepak Barnwal barnwaldee...@gmail.comwrote: PFA Regards deepak On Fri, Jul 26, 2013 at 11:28 PM, vba v...@vabs.in wrote: PFA Actually years should be 37 not 36!! HTH//Cheers On Fri, Jul 26, 2013 at 10:12 AM, Shankar

$$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

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

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
:* Shankar Bheema shankar.n...@gmail.com *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. Conditions are: i

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
shankar.n...@gmail.com *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. Conditions are: i) Date

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
:* $$Excel-Macros$$ date difference 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

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
@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. 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

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Shankar Bheema
*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. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
...@gmail.com *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. Conditions are: i) Date of Retirement

Re: $$Excel-Macros$$ date difference

2011-09-12 Thread Sam Mathai Chacko
*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. Conditions are: i) Date of Retirement should be 60 years after Date of Birth eg. if date of birth

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 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 Shankar Bheema
*From:* dguillett1 dguille...@gmail.com *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 offering. *From

Re: $$Excel-Macros$$ Date Difference

2011-07-02 Thread Chandra Shekar
Thanks a lot :-) On Fri, Jul 1, 2011 at 6:06 PM, ashish koul koul.ash...@gmail.com 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

$$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

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 chandrashekarb@gmail.com 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

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 and sundays