Re: $$Excel-Macros$$ Date doubt

2013-07-27 Thread De Premor
Friday of december to next year's last Thursday of december. Thanks in adv. *From:* De Premor *To:* excel-macros@googlegroups.com *Sent:* Saturday, July 27, 2013 3:32 AM *Subject:* Re: $$Excel-Macros$$ Date doubt

Re: $$Excel-Macros$$ Date doubt

2013-07-26 Thread De Premor
ans from 28 dec 2012 - 28march 2013, and 29 march 2013 to 27june 2013 half year means for eg : 28dec 2012 - 27june 2013, then 28 june 2013 to 26dec2013 yearly means 28dec2012 - 26dec 2013 any month starts from last Friday of the month and ends on last Thursday of next month. this is the pattern o

Re: $$Excel-Macros$$ Date doubt

2013-07-26 Thread De Premor
any month starts from last Friday of the month and ends on last Thursday of next month. this is the pattern of contracts followed in indian stock markets. Pls find the file attched. Thanks in adv. ------------ *From:* De Premor *To

Re: $$Excel-Macros$$ Date doubt

2013-07-26 Thread Kenil Gala
. From: De Premor To: excel-macros@googlegroups.com Sent: Friday, July 26, 2013 6:40 AM Subject: Re: $$Excel-Macros$$ Date doubt First Approach This function is to find first Friday on every given range, is this match to your requirement ? if not, please reply

Re: $$Excel-Macros$$ Date doubt

2013-07-25 Thread De Premor
First Approach This function is to find first Friday on every given range, is this match to your requirement ? if not, please reply with data and date as you want on each range. Confuse on this statement "month from last Friday to last Thursday of the month.", sample data needed. Function fin

$$Excel-Macros$$ Date doubt

2013-07-25 Thread Kenil Gala
Hi friends, i have a query for arranging dates in a pattern. Pls help me solve my query. Thanks in adv. -- 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 R