Dear Mr.DP.
Thanks a ton. Yes it computes on daily basis. It certainly helps me.
I had small difficulty. There is some problem. The total of the
allocated amount exceeds value when we take it from beginning.
Example the first of if I put date of 1-Oct-13 to some end date,
It allocates on number of days.. But sum of the allocation
exceeds amount to be allocated. Is it possible to rectify this
issues?
Attached the work sheet.
rgds
On 23 July 2013 21:11, De Premor <d...@premor.net
<mailto:d...@premor.net>> wrote:
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. 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 this example the first month distribution
should be 27 days and in the month of December, it should be
proportionate to 14 days. The balance should be distributed
equally for other months for whole month.
Is it something possible?
best regards
vishwanath
On Thursday, July 18, 2013 10:11:28 PM UTC+5:30, ashish wrote:
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
<py.h...@gmail.com> wrote:
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
future generation_*
*1 ream of paper = 6% of a tree and 5.4 kg CO2 in
the atmosphere
3 sheets of A4 paper pollutes 1 litre of water*
--
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...@googlegroups.com.
To post to this group, send email to
excel-...@googlegroups.com.
Visit this group at
http://groups.google.com/group/excel-macros.
For more options, visit
https://groups.google.com/groups/opt_out.
--
*Regards*
**
*Ashish Koul*
*/Visit/*
*/_My Excel Blog <http://www.excelvbamacros.com/>_/*
Like Us on Facebook
<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/151803898222297>
Join Us on Facebook
<http://www.facebook.com/groups/163491717053198/>
PBefore printing, think about the environment.
--
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
<mailto:excel-macros+unsubscr...@googlegroups.com>.
To post to this group, send email to
excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit
https://groups.google.com/groups/opt_out.
--
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 a
topic in the Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/excel-macros/8hCtyxYyVtY/unsubscribe.
To unsubscribe from this group and all its topics, send an
email to excel-macros+unsubscr...@googlegroups.com
<mailto:excel-macros%2bunsubscr...@googlegroups.com>.
To post to this group, send email to
excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
--
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
<mailto:excel-macros+unsubscr...@googlegroups.com>.
To post to this group, send email to
excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com>.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
