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
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
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
:* 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
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
:* $$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
@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
*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
...@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
*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
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
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
*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
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
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
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
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
17 matches
Mail list logo