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