Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread Sunil Kumar Yadav
; 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 > > > &g

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS 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

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS 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

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, derrickandrew994 via MS EXCEL AND VBA MACROS 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

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, Sunil Kumar Yadav 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

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread Sunil Kumar Yadav
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 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 cal

$$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread Sunil Kumar Yadav
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