# Allocating costs dependant on date input

1. ## Allocating costs dependant on date input

Hi All apologies,

In the attached sample i need to be able to put in the dates off and on and then under each month this will populate how much is to be allocated to that month.

For example on my sample the 1st item Signs Cones & Equipment will be on hire from 04/01/20 untill 20/05/20 at a rate of £20/week

Jan will therefore be 4 weeks at £20/week and so on until May which as it ends on 20/05/20 there will be 2.6 weeks so under May there will be £52 of costs allocated

Thanks again

2. ## Re: Allocating costs dependant on date input

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

3. ## Re: Allocating costs dependant on date input

I agree attach a spreadsheet, and suppect you will wish to add holidays
you want the working days between (the maximum of the start of the months and the start date for the activty) and the minimum of the start of the next month and the end of the activity. If the dates are outside this range, the answer is 0

=MAX(0,NETWORKDAYS(MAX(C\$1,\$A2),MIN(\$B2,D\$1)))*21.84

where C1 1/1/20
d1 1/2/20
A2 19/1/20
B2 4/3/20
21.84 is daily rate

4. ## Re: Allocating costs dependant on date input

Much appreciated

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1