I'm looking for help with a formula to distribute an amount across the impacted months based on a date range.
Total Cost is $100,000.00
Start Date is 1/17/18
End Date is 4/8/18
I'd like the formula to consider only working days. Can anyone help with a formula that will tell me how much of the cost will be in Jan vs Feb vs Mar vs Apr?
Thanks.
Nadine
try something like this (as a start)
=100000/NETWORKDAYS(K2,L2)
copied across the period
To give more detailed suggestion (such as determining where to actually start and end calcs), upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
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
I've uploaded my file. I think the formula needs more or else I entered it wrong. Thanks.
*Forgot to mention that the amounts in yellow in each month are the desired results for the formula.
Try this in E2:
=MAX(NETWORKDAYS(MAX($B2,E$1),MIN(EOMONTH(E$1,0),$C2)),0)*$D2/NETWORKDAYS($B2,$C2)
Hi May be this e2=
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Thank you Phuocam. This worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks