spread revenue or value over months by using start date and end date
Hi,
Can someone help me on how to do a formula on how to spread the value by using the start date and end date. I need to spread it out evenly by using the start date as the start month and end date as the end month to be spread out.
Example
my start date is under column D (11/27/2013)
my end date is under colum E (11/27/2013)
my value is under column M $1000.00
column n to BP is where i need to spread the amount ( Jan-13 to December-13)
Please let me know. I would appreciate it very much
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually and exactly as needed. Don't invent a fake layout, show us your actual design and mocked up required results based on mocked up sample data.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
_________________
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!)
There's a workbook with a bunch of examples of how to do this at https://app.box.com/shared/7xm2kt408n
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks