Distribute revenue across months
Hi there,
Could somebody help me please!!!
I need a formula that will allow to split the revenue accross the months, taking into account of when the promotion starts and ends and how many days it runs in that month. Somthing that can be easily dragged accross and will still work.
Many thanks.
Dont have an answer yet, posting so I know where to come back to, later
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Put this in L3, then copy across and down.
=IF(OR(L$2<$C3, L$1>$D3), "", (MEDIAN($C3, $D3, L$2)-MEDIAN($C3, $D3, L$1)+1)*$K3)
Does that work for you?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I interpreted a bit differently.Formula:
Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks