t;>>
>>>
>>>
>>> Still try with this
>>>
>>>
>>>
>>> “mmm'”
>>>
>>>
>>>
>>>
>>>
>>> Regards,Anil Bhange
>>>
>>> IP Phone - 512320 | Mobile - 9
t;
>> *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
>>
>>
>&g
; 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:
o: 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 co
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 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 exampl
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 wrote:
>
>
change
"dd-mmm-" to
"dd-mmm'" in formula
On Sat, May 7, 2011 at 7:47 AM, Mr excel 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
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 a
try this one
On Thu, May 5, 2011 at 9:11 PM, ashish koul wrote:
> see if it helps
>
>
> On Thu, May 5, 2011 at 7:23 AM, Mr excel 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
see if it helps
On Thu, May 5, 2011 at 7:23 AM, Mr excel 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 t
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 colum
can you expaln with some example in workbook
On Tue, May 3, 2011 at 8:30 PM, keechak 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
12 matches
Mail list logo
