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