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