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 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.
To post to this group, send email to 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.
To post to this group, send email to 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.
