Dear Paul, Pls revert, if you have time.
On Mar 17, 2017 5:22 PM, "karleenbiggs via MS EXCEL AND VBA MACROS" < excel-macros@googlegroups.com> wrote: > > -------------------------------------------- > On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS < > excel-macros@googlegroups.com> wrote: > > Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly > basis as per date > To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 1:50 PM > > > -------------------------------------------- > On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS > <excel-macros@googlegroups.com> > wrote: > > Subject: Re: $$Excel-Macros$$ How to pick rental on > pro-rata/monthly basis as per date > To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 11:41 AM > > > -------------------------------------------- > On Fri, 3/17/17, derrickandrew994 via MS EXCEL AND VBA > MACROS <excel-macros@googlegroups.com> > wrote: > > Subject: Re: $$Excel-Macros$$ How to pick rental on > pro-rata/monthly basis as per date > To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 9:44 AM > > > -------------------------------------------- > On Fri, 3/17/17, Sunil Kumar Yadav <sk.yadav7...@gmail.com> > wrote: > > Subject: Re: $$Excel-Macros$$ How to pick rental on > pro-rata/monthly basis as per date > To: excel-macros@googlegroups.com > Date: Friday, March 17, 2017, 9:17 AM > > Dear Paul, > > I want to > formula in one column not month-wise separately. > > Please guide > me! > > On Fri, Mar 17, 2017 at > 12:44 PM, Sunil Kumar Yadav <sk.yadav7...@gmail.com> > wrote: > Dear Team, > > I want to pick > rental pro-rata/monthly as per purchasing date. > > Pro-rata - > If purchasing date after 1st then rental will be > calculated > days-wise(count) > > monthly - If > purchasing date 1st then rental will be paid full. > > -- > Sky > > > "Good, Better, > Best!Always listen > to your heart, because there lives your > parents. > > > > > -- > > 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. > > > > > -- > Sky > > > "Good, Better, > Best!Always listen to > your heart, because there lives your > parents. > > > > > -- > > 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. > 8 21 ian. - Romania ia parte > la deschiderea lucrarilor Conferintei de pace de > la > Paris. > > -- > 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.ducat- > teritoriu stat condus de un duce sau ducesa > > -- > 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.age 29 > of 131separai de distana - el la Bucureti ea la Iai - > se vedeau rar in schimb purtau o frecventa > corespondena. [tatalui sau in 18 mar. 1881 la 31 > de ani] Bucureti 18 martie 1881 Iubite Tata M-am > bucurat mult primind scrisoarea d-tale in versuri i m-am > intristat asemenea afland din ea ca nu eti tocmai bine. > Altfel i eu am avut acele friguri de primavara atat de > obicinuite in ara la noi. N-am raspuns numaidecat pentru ca > m-a apucat proclamarea regatului 1 pe dinainte i-n asemenea > imprejurari noi negustorii de gogoi i de braoave > adica noi gazetarii suntem foarte ocupai 2 . A dori > din toata inima sa vin acasa sa va vad dac-a gasi vrun > om de incredere care sa-mi ie locul caci negustoria > asta pe langa ca n-aduce nimic nici nu te > ingaduie sa inchizi o zi doua dugheana i sa mai iei lumea-n > cap ci-n toate zilele trebuie omul sa-i bata capul ca > sa afle minciuni noua. Dac-oi putea scapa iubite > tata fie acum fie la vara vin desigur > acasa. il rog pe Nicu a sa-mi scrie mai des i sa nu se uite > la aceea ca nu-i raspund caci daca am aa de > puina vreme de scris i daca mi-e acru sufletul de cerneala i > de condei citesc totui cu multa bucurie scrisorile ce > le primesc de la d-voastra. Sarutandu-i manile i dorindu-i > multa sanatate i voie buna raman al d-tale supus fiu Mihai > 1. proclamarea regatului - Romania a fost proclamata regat - > i Carol I incoronat rege - in 14 martie 1881. 2. noi > gazetarii suntem foarte ocupai - Eminescu era pe > atunci redactor-ef la ziarul conservator Timpul i scria > ziarul in buna parte el singur. 29 Page 29 of 131 > > -- > 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. dl. director al fabricii si > secretarul Comisiei Generale a Sindicatelor din tara si din onor > > -- > 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.