RE: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread Ravi Kumar
Did u try this formula.

 

 

Principle(1+rate/100)^month

 

Like 

 

500(1+5/100)^5

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sridher sharma
Sent: Monday, September 09, 2013 4:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ EX-QUERY

 

Dear member plz help me

 

I am calculating compound interest on loan over a period where interest is
compounded either Monthly, Quarterly, Semi- Annually and Annually.

But it is stands valid in case of Non- leap years. Please give me a formulae
for leap years.

 

Regards,

SRIDHER SHARMA

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! 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 Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com
mailto:excel-macros+unsubscr...@googlegroups.com .
To post to this group, send email to excel-macros@googlegroups.com
mailto:excel-macros@googlegroups.com .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread sridher sharma
yes i used this formula
but  it is stands valid in case of Non- leap years, Please give me
a formula for leap years.


On 9 September 2013 16:18, Ravi Kumar excellearn2...@gmail.com wrote:

 Did u try this formula…

 ** **

 ** **

 Principle(1+rate/100)^month

 ** **

 Like 

 ** **

 500(1+5/100)^5

 ** **

 * *

 *Warm Regards,*

 *Ravi Kumar.*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *sridher sharma
 *Sent:* Monday, September 09, 2013 4:08 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ EX-QUERY

 ** **

 Dear member plz help me

  

 I am calculating compound interest on loan over a period where interest is
 compounded either Monthly, Quarterly, Semi- Annually and Annually.

 But it is stands valid in case of Non- leap years. Please give me a
 formulae for leap years.

  

 *Regards,*

 *SRIDHER SHARMA*

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread Sandeep Kumar Chhajer
Dear sridhar,

I did not get you how leap year or non leap year affecting your result.

Can you send us example.

Sandeep Chhajer. 
Sent on my BlackBerry® from Vodafone

-Original Message-
From: sridher sharma sridher.sha...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 9 Sep 2013 16:22:16 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ EX-QUERY

yes i used this formula
but  it is stands valid in case of Non- leap years, Please give me
a formula for leap years.


On 9 September 2013 16:18, Ravi Kumar excellearn2...@gmail.com wrote:

 Did u try this formula…

 ** **

 ** **

 Principle(1+rate/100)^month

 ** **

 Like 

 ** **

 500(1+5/100)^5

 ** **

 * *

 *Warm Regards,*

 *Ravi Kumar.*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *sridher sharma
 *Sent:* Monday, September 09, 2013 4:08 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ EX-QUERY

 ** **

 Dear member plz help me

  

 I am calculating compound interest on loan over a period where interest is
 compounded either Monthly, Quarterly, Semi- Annually and Annually.

 But it is stands valid in case of Non- leap years. Please give me a
 formulae for leap years.

  

 *Regards,*

 *SRIDHER SHARMA*

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! 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 Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread sridher sharma
Thanks for your response.

I have a spreadsheet where there is a date range say 01-01-10 to 01-01-13.
Now, I need the difference in the date range expressed in terms of years.
So, leap year should also be taken in to account for the same.

Can you please refer me a function or a formulae for this?


On 9 September 2013 17:11, Sandeep Kumar Chhajer
chhajersand...@gmail.comwrote:

 **
 Dear sridhar,

 I did not get you how leap year or non leap year affecting your result.

 Can you send us example.

 Sandeep Chhajer.
 Sent on my BlackBerry® from Vodafone
 --
 *From: * sridher sharma sridher.sha...@gmail.com
 *Sender: * excel-macros@googlegroups.com
 *Date: *Mon, 9 Sep 2013 16:22:16 +0530
 *To: *excel-macros@googlegroups.com
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ EX-QUERY

 yes i used this formula
 but  it is stands valid in case of Non- leap years, Please give me
 a formula for leap years.


 On 9 September 2013 16:18, Ravi Kumar excellearn2...@gmail.com wrote:

 Did u try this formula…

 ** **

 ** **

 Principle(1+rate/100)^month

 ** **

 Like 

 ** **

 500(1+5/100)^5

 ** **

 * *

 *Warm Regards,*

 *Ravi Kumar.*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *sridher sharma
 *Sent:* Monday, September 09, 2013 4:08 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ EX-QUERY

 ** **

 Dear member plz help me

  

 I am calculating compound interest on loan over a period where interest
 is compounded either Monthly, Quarterly, Semi- Annually and Annually.

 But it is stands valid in case of Non- leap years. Please give me a
 formulae for leap years.

  

 *Regards,*

 *SRIDHER SHARMA*

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread sridher sharma
No One there to resolve my problem ???



On 9 September 2013 17:25, sridher sharma sridher.sha...@gmail.com wrote:

 Thanks for your response.

 I have a spreadsheet where there is a date range say 01-01-10 to 01-01-13.
 Now, I need the difference in the date range expressed in terms of years.
 So, leap year should also be taken in to account for the same.

 Can you please refer me a function or a formulae for this?


 On 9 September 2013 17:11, Sandeep Kumar Chhajer chhajersand...@gmail.com
  wrote:

 **
 Dear sridhar,

 I did not get you how leap year or non leap year affecting your result.

 Can you send us example.

 Sandeep Chhajer.
 Sent on my BlackBerry® from Vodafone
 --
 *From: * sridher sharma sridher.sha...@gmail.com
 *Sender: * excel-macros@googlegroups.com
 *Date: *Mon, 9 Sep 2013 16:22:16 +0530
 *To: *excel-macros@googlegroups.com
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ EX-QUERY

 yes i used this formula
 but  it is stands valid in case of Non- leap years, Please give me
 a formula for leap years.


 On 9 September 2013 16:18, Ravi Kumar excellearn2...@gmail.com wrote:

 Did u try this formula…

 ** **

 ** **

 Principle(1+rate/100)^month

 ** **

 Like 

 ** **

 500(1+5/100)^5

 ** **

 * *

 *Warm Regards,*

 *Ravi Kumar.*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *sridher sharma
 *Sent:* Monday, September 09, 2013 4:08 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ EX-QUERY

 ** **

 Dear member plz help me

  

 I am calculating compound interest on loan over a period where interest
 is compounded either Monthly, Quarterly, Semi- Annually and Annually.***
 *

 But it is stands valid in case of Non- leap years. Please give me a
 formulae for leap years.

  

 *Regards,*

 *SRIDHER SHARMA*

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure

Re: $$Excel-Macros$$ EX-QUERY

2013-09-09 Thread ashish koul
have you tried datedif  function
http://www.techonthenet.com/excel/formulas/datedif.php


On Mon, Sep 9, 2013 at 6:58 PM, sridher sharma sridher.sha...@gmail.comwrote:

 No One there to resolve my problem ???



 On 9 September 2013 17:25, sridher sharma sridher.sha...@gmail.comwrote:

 Thanks for your response.

 I have a spreadsheet where there is a date range say 01-01-10 to 01-01-13.
 Now, I need the difference in the date range expressed in terms of years.
 So, leap year should also be taken in to account for the same.

 Can you please refer me a function or a formulae for this?


 On 9 September 2013 17:11, Sandeep Kumar Chhajer 
 chhajersand...@gmail.com wrote:

 **
 Dear sridhar,

 I did not get you how leap year or non leap year affecting your result.

 Can you send us example.

 Sandeep Chhajer.
 Sent on my BlackBerry® from Vodafone
 --
 *From: * sridher sharma sridher.sha...@gmail.com
 *Sender: * excel-macros@googlegroups.com
 *Date: *Mon, 9 Sep 2013 16:22:16 +0530
 *To: *excel-macros@googlegroups.com
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ EX-QUERY

 yes i used this formula
 but  it is stands valid in case of Non- leap years, Please give me
 a formula for leap years.


 On 9 September 2013 16:18, Ravi Kumar excellearn2...@gmail.com wrote:

 Did u try this formula…

 ** **

 ** **

 Principle(1+rate/100)^month

 ** **

 Like 

 ** **

 500(1+5/100)^5

 ** **

 * *

 *Warm Regards,*

 *Ravi Kumar.*

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *sridher sharma
 *Sent:* Monday, September 09, 2013 4:08 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ EX-QUERY

 ** **

 Dear member plz help me

  

 I am calculating compound interest on loan over a period where interest
 is compounded either Monthly, Quarterly, Semi- Annually and Annually.**
 **

 But it is stands valid in case of Non- leap years. Please give me a
 formulae for leap years.

  

 *Regards,*

 *SRIDHER SHARMA*

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! 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 Advice
 will not get quick