Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-23 Thread De Premor
You're welcome, glad to know it solve the problem Have a good days Pada 24/07/2013 1:34, Vishwanath menulis: Dear Mr.DP.. Awesome... I admire it. You have reduced my whole day effort to few minutes.. My heart filled thanks to you. Best regards Vishwanath On 23 July 2013 23:55, De Premor

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-23 Thread Vishwanath
Dear Mr.DP.. Awesome... I admire it. You have reduced my whole day effort to few minutes.. My heart filled thanks to you. Best regards Vishwanath On 23 July 2013 23:55, De Premor wrote: > Ups Sorry, i dont make an error checking before > here is the rev code > > > =(EOMONTH(D$4,0)>$A5)*(D$4<

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-23 Thread De Premor
Ups Sorry, i dont make an error checking before here is the rev code =(EOMONTH(D$4,0)>$A5)*(D$4<$B5)*IF(EOMONTH(D$4,0)>$B5,DAY($B5),DAY(EOMONTH(D$4,0))-IF(D$4<*=*$A5,DAY($A5),0))*($C5/($B5-$A5)) Rgds [dp] Pada 24/07/2013 1:15, Vishwanath menulis: Dear Mr.DP. Thanks a ton. Yes it computes on d

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-23 Thread De Premor
Paste this in Cell G5, then copy left and down *=(EOMONTH(G$4,0)>$D5)*(G$4<$E5)*IF(EOMONTH(G$4,0)>$E5,DAY($E5),DAY(EOMONTH(G$4,0))-IF(G$4<$D5,DAY($D5),0))*($F5/($E5-$D5))** * Formula above will calculate on daily basis Rgds, [dp] Pada 23/07/2013 21:33, Vishwanath menulis: Dear Ashish, Thanks.

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-23 Thread Vishwanath
Dear Ashish, Thanks. I was looking for similar solution. But data structure remains the same. But the amount should be distributed prorated for first month and last month.. For Example. In the first month... the amount should be proportion to number of days rather than equal distribution. in

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-18 Thread ashish koul
Try this formula =IF(AND(G$4>=DATE(YEAR($D5),MONTH($D5),1),G$4<=DATE(YEAR($E5),MONTH($E5),1)),$F5/(DATEDIF($D5,$E5,"m")+1),"") see if it helps On Thu, Jul 18, 2013 at 5:01 PM, Harish P Y wrote: > Please find the attached file and help me for the formula . > When the start date and date are i

$$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-18 Thread Harish P Y
Please find the attached file and help me for the formula . When the start date and date are in different years With Regards *HARISH P Y* *P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it is really necessary. Thanks for your support to protect our environment for the