Re: $$Excel-Macros$$ Calculate Due dates
It is the same worksheet bhayya which i had attched previously.Just need to change the formula or add a routine for my requirement. Thanks in advance. On Sun, May 15, 2011 at 9:43 AM, ashish koul koul.ash...@gmail.com wrote: can you attach the sample sheet On Sat, May 14, 2011 at 6:20 PM, Mr excel excelkeec...@gmail.com wrote: Thanks ashish bhayya for that great formula.Upon drilling deep into the formula the result,i feel we are into the logical error.To make it clear, for Supplier A, if the transaction date is *12/05/2001*.the formula should return the previous month just like, *05-Apr'2011 TO 04-May'2011.Kindly update the formula. Thanks in advance. * On Thu, May 12, 2011 at 9:41 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: I think Ashish is right use this, Still try with this “mmm'” Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mr excel *Sent:* Wednesday, May 11, 2011 8:37 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Calculate Due dates what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks
Re: $$Excel-Macros$$ Calculate Due dates
Thanks ashish bhayya for that great formula.Upon drilling deep into the formula the result,i feel we are into the logical error.To make it clear, for Supplier A, if the transaction date is *12/05/2001*.the formula should return the previous month just like, *05-Apr'2011 TO 04-May'2011.Kindly update the formula. Thanks in advance. * On Thu, May 12, 2011 at 9:41 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: I think Ashish is right use this, Still try with this “mmm'” Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mr excel *Sent:* Wednesday, May 11, 2011 8:37 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Calculate Due dates what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel
Re: $$Excel-Macros$$ Calculate Due dates
can you attach the sample sheet On Sat, May 14, 2011 at 6:20 PM, Mr excel excelkeec...@gmail.com wrote: Thanks ashish bhayya for that great formula.Upon drilling deep into the formula the result,i feel we are into the logical error.To make it clear, for Supplier A, if the transaction date is *12/05/2001*.the formula should return the previous month just like, *05-Apr'2011 TO 04-May'2011.Kindly update the formula. Thanks in advance. * On Thu, May 12, 2011 at 9:41 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: I think Ashish is right use this, Still try with this “mmm'” Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mr excel *Sent:* Wednesday, May 11, 2011 8:37 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Calculate Due dates what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating
RE: $$Excel-Macros$$ Calculate Due dates
I think Ashish is right use this, Still try with this mmm' Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr excel Sent: Wednesday, May 11, 2011 8:37 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Calculate Due dates what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,05-Apr-2011 TO 04-May-2011. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul koul.ash...@gmail.commailto:koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.commailto:excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of 05-Apr-2011 TO 04-May-2011. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.commailto:koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.commailto:koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.commailto:excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers... Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.commailto:koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.commailto:excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.comhttp://akoul.blogspot.com/ akoul.wordpress.comhttp://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our
Re: $$Excel-Macros$$ Calculate Due dates
what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.comwrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.comwrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.comwrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.comwrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com
Re: $$Excel-Macros$$ Calculate Due dates
Got it ashish bhayya..thanks a lot.played with the formula and got the desired result.. Thanks a lot. On Wed, May 11, 2011 at 8:37 PM, Mr excel excelkeec...@gmail.com wrote: what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul koul.ash...@gmail.com wrote: change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.comwrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.comwrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.comwrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.comwrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My
Re: $$Excel-Macros$$ Calculate Due dates
change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.comwrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.comwrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel
Re: $$Excel-Macros$$ Calculate Due dates
dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @
Re: $$Excel-Macros$$ Calculate Due dates
see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel DATE Q.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Calculate Due dates
try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel DATE_Q.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Calculate Due dates
can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.com wrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Calculate Due dates
Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Samplesheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet