Hello Team, issue got resolved. Thanks All :)
Regards, Chandru On Mon, Jul 31, 2017 at 8:42 AM, 'Storey Thomas' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: > > -------------------------------------------- > On Sun, 7/30/17, 'Yu Spain' via MS EXCEL AND VBA MACROS < > excel-macros@googlegroups.com> wrote: > > Subject: Re: $$Excel-Macros$$ Help on Week Formula > To: excel-macros@googlegroups.com > Date: Sunday, July 30, 2017, 11:56 PM > > > -------------------------------------------- > On Sun, 7/30/17, 'Martinez David' via > MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > wrote: > > Subject: Re: $$Excel-Macros$$ Help on > Week Formula > To: excel-macros@googlegroups.com > Date: Sunday, July 30, 2017, 8:42 PM > > > > -------------------------------------------- > On Sun, 7/30/17, 'Hopkins Ruben' via > MS > EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > wrote: > > Subject: Re: $$Excel-Macros$$ > Help on > Week Formula > To: excel-macros@googlegroups.com > Date: Sunday, July 30, 2017, > 3:31 PM > > > > > -------------------------------------------- > On Sun, 7/30/17, Chandra Shekar > <chandrashekarb....@gmail.com> > wrote: > > Subject: Re: $$Excel-Macros$$ > Help on > Week Formula > To: excel-macros@googlegroups.com > Date: Sunday, July 30, 2017, > 2:57 PM > > Hello > Paul, > For Ex: If I > mention date as 07/01/2017(Sat) > formula should give Week 1 > from there every week it should > increase by 1.1) > 07-01-2017 to 07-07-2017 = > Week12) > 22-01-2017 to > 28-07-2017 = Week43) 29-07-2017 > - > 04-08-2017 = > Week5 > Regards, > Chandru > On Tue, Jul 25, 2017 at > 4:31 PM, Paul Schreiner <schreiner_p...@att.net> > wrote: > I > think you'll need to be more > specific > on how you want > the "weeks" calculated.For > instance, in > August (2017) August 1 > is on a > Tuesday. > so, > the weeks are handled: > > but, > July 1 is on a Saturday,so, > does Week 1 only have a single > day? > Or > is July 1 counted as part of > week 5 of > June.If > so, what is the minimum number > of days > counted in a week > 1? > Or > are you wanting a simple count > of > days:Week > 1 = first 7 daysWeek > 2 = Second 7 daysetc. > > Paul------------------------------ > ----------- > “Do > all the good you can, > By all the means you > can, > In all the ways you can, > In all the places you can, > At > all the times you can, > To all the people you > can, > As long as ever you can.” - > John > Wesley > ------------------------------ > ----------- > > > > On Tuesday, July 25, 2017 > 3:34 > AM, > Chandra Shekar <chandrashekarb....@gmail.com> > wrote: > > > Hello Team, > Could you please help me in > attached > week formula. > Regards, > Chandru > > > > -- > > 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 RULES > > > > 1) Use concise, accurate thread > titles. Poor thread titles, > like Please Help, Urgent, Need > Help, > Formula Problem, Code > Problem, and Need Advice will > not get > quick attention or may > not be answered. > > 2) Don't post a question in the > thread > of another > member. > > 3) Don't post questions > regarding > breaking or bypassing > any security measure. > > 4) Acknowledge the responses > you > receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material > and > their links is not > allowed. > > > > NOTE : Don't ever post > confidential data in a > workbook. > Forum owners and members are > not > responsible for any > loss. > > --- > > You received this message > because you > are subscribed to the > Google Groups "MS EXCEL AND VBA > MACROS" group. > > To unsubscribe from this group > and > stop receiving emails > from it, send an email to > excel-macros+unsubscribe@ > googlegroups.com. > > To post to this group, send > email to > excel-macros@googlegroups.com. > > Visit this group at https://groups.google.com/ > group/excel-macros. > > For more options, visit https://groups.google.com/d/ > optout. > > > > > > > > -- > > 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 RULES > > > > 1) Use concise, accurate thread > titles. Poor thread titles, > like Please Help, Urgent, Need > Help, > Formula Problem, Code > Problem, and Need Advice will > not get > quick attention or may > not be answered. > > 2) Don't post a question in the > thread > of another > member. > > 3) Don't post questions > regarding > breaking or bypassing > any security measure. > > 4) Acknowledge the responses > you > receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material > and > their links is not > allowed. > > > > NOTE : Don't ever post > confidential data in a > workbook. > Forum owners and members are > not > responsible for any > loss. > > --- > > You received this message > because you > are subscribed to the > Google Groups "MS EXCEL AND VBA > MACROS" group. > > To unsubscribe from this group > and > stop receiving emails > from it, send an email to > excel-macros+unsubscribe@ > googlegroups.com. > > To post to this group, send > email to > excel-macros@googlegroups.com. > > Visit this group at https://groups.google.com/ > group/excel-macros. > > For more options, visit https://groups.google.com/d/ > optout. > > > > > > > -- > > 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 RULES > > > > 1) Use concise, accurate thread > titles. Poor thread titles, > like Please Help, Urgent, Need > Help, > Formula Problem, Code > Problem, and Need Advice will > not get > quick attention or may > not be answered. > > 2) Don't post a question in the > thread > of another > member. > > 3) Don't post questions > regarding > breaking or bypassing > any security measure. > > 4) Acknowledge the responses > you > receive, good or bad. > > 5) Jobs posting is not allowed. > > 6) Sharing copyrighted material > and > their links is not > allowed. > > > > NOTE : Don't ever post > confidential data in a > workbook. > Forum owners and members are > not > responsible for any > loss. > > --- > > You received this message > because you > are subscribed to the > Google Groups "MS EXCEL AND VBA > MACROS" group. > > To unsubscribe from this group > and > stop receiving emails > from it, send an email to > excel-macros+unsubscr...@googlegroups.com. > > To post to this group, send > email to > excel-macros@googlegroups.com. > > Visit this group at > > > https://groups.google.com/group/excel-macros. > > For more options, visit > > https://groups.google.com/d/optout. > rave probleme economice > sociale > si sanitare pe care statul > in > ciuda unor > > -- > 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 RULES > > 1) Use concise, accurate thread > titles. > Poor thread titles, like Please > Help, > Urgent, Need Help, > Formula Problem, Code Problem, > and > Need Advice will not get > quick attention or may not be > answered. > 2) Don't post a question in the > thread > of another member. > 3) Don't post questions > regarding > breaking or bypassing any > security > measure. > 4) Acknowledge the responses > you > receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material > and > their links is not allowed. > > NOTE : Don't ever post > confidential data in a workbook. > Forum > owners and members > are not responsible for any > loss. > --- > You received this message > because you > are subscribed to the Google > Groups > "MS EXCEL AND VBA > MACROS" group. > To unsubscribe from this group > and > stop > receiving emails from it, send > an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send > email to > excel-macros@googlegroups.com. > Visit this group at > > > https://groups.google.com/group/excel-macros. > For more options, visit > https://groups.google.com/d/optout.ezistenta > sau cedarea au fost cele doua variante > ale alternativei > tragice in care se gasea Romania si pe > care Ie-a luat in > discutie Consiliul de Coroana > convocat de doua ori in > cursul zilei. in cele din urma > nevoia de a pastra > armata si statul s-au dovedit mai > puternice. Din 26 de > participanti doar 6 s-au pronuntat > pentru rezistenta > in frunte aflandu-se profesorul > Nicolae orga > urmat de Silviu Dragomir si stefan > Ciobanu. > > -- > 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 RULES > > 1) Use concise, accurate thread > titles. > Poor thread titles, like Please Help, > Urgent, Need Help, > Formula Problem, Code Problem, and > Need Advice will not get > quick attention or may not be > answered. > 2) Don't post a question in the > thread > of another member. > 3) Don't post questions regarding > breaking or bypassing any security > measure. > 4) Acknowledge the responses you > receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and > their links is not allowed. > > NOTE : Don't ever post > confidential data in a workbook. Forum > owners and members > are not responsible for any loss. > --- > You received this message because you > are subscribed to the Google Groups > "MS EXCEL AND VBA > MACROS" group. > To unsubscribe from this group and > stop > receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to > excel-macros@googlegroups.com. > Visit this group at > > https://groups.google.com/group/excel-macros. > For more options, visit > https://groups.google.com/d/optout.rmeaza > lovitura de stat de la 2 mai 1864. in iunie 1865 > opozitionistii conservatori si liberali semneaza un legamant > : domnitorul sa fie silit sa abdice eventual chiar > printr-o actiune armata armele erau deja > procurate in caz de vacanta a tronului tot > prin toate mijloacele urme a se actiona pentru > alegerea unui principe dintr-una din familiile domnitoare > din Occident . > > -- > 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 RULES > > 1) Use concise, accurate thread titles. > Poor thread titles, like Please Help, Urgent, Need Help, > Formula Problem, Code Problem, and Need Advice will not get > quick attention or may not be answered. > 2) Don't post a question in the thread > of another member. > 3) Don't post questions regarding > breaking or bypassing any security measure. > 4) Acknowledge the responses you > receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and > their links is not allowed. > > NOTE : Don't ever post > confidential data in a workbook. Forum owners and members > are not responsible for any loss. > --- > You received this message because you > are subscribed to the Google Groups "MS EXCEL AND VBA > MACROS" group. > To unsubscribe from this group and stop > receiving emails from it, send an email to excel-macros+unsubscribe@ > googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at > https://groups.google.com/group/excel-macros. > For more options, visit > https://groups.google.com/d/optout.oile conditii ale luptei pentru > independenta in a doua jumatate a secolului al XIX-'lea Faurirea statului > national roman in 1859 prin unirea Munteniei cu Moldova sub sceptrul lui > Alexandru loan Cuza si reformele ce i-au urmat pe directia modernizarii au > constituit temelia cuceririi independentei. Aceasta a ramas in continuare > la jumatatea secolului trecut telul major al romanilor din toate > provinciile. in cercurile politice exista o unanimitate de pareri in > favoarea obtinerii independentei. in privinta metodelor preconizate pentru > implinirea acestui scop s-au conturat insa diferente sensibile de opinii > intre diferitele forte sociale si politice. Ele oscilau intre razboi > cercurile radicale si calea diplomatica cercurile monarhice . Cea din > urma era sustinuta de unii liberali moderati s\ marii proprietari funciari. > Vasile Boerescu sau Gheorghe Costaforu au apreciat astfef ca razboiul din > 1870-1871 dintre Franta si Prusia putea crea conditiile pentru a se > conferi Romaniei statutul de neutralitate si independenta sub garantia > Marilor Puteri. Lascar Catarg u considera ca doar o apropiere de Germania > Austro-Ungaria si Rusia putea aduce independenta tarii noastre. La 27 > aprilie 3 mai 1873 Caro a pus in discutia guvernului in mod deschis > problema independentei de stat. in acelasi timp multe nazuinte erau legate > de cucerirea independentei si anume imbunatatirea conditiilor de viata > rezolvarea chestiunii taranesti dezvoltarea industriei si adoptarea unor > masuri protectioniste. > > -- > 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 RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
