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