Allocate a sum of money on a daily basis

[philiphales]

I have a start date and an end date, networkdays gives me the number of working days. I have a sum of money I want allocating to each working day. Please show me how?

 

[Shteven]

Assuming you would like the amount allocated evenly per day:

=SUMOFMONEY/NETWORKDAYS(DATE1,DATE2)

 

[philiphales]

I have a start date and an end date, networkdays gives me the number of working days. I have a sum of money I want allocating to each working day. Please show me how?

Assuming you would like the amount allocated evenly per day:

=SUMOFMONEY/NETWORKDAYS(DATE1,DATE2)

Hi
I have added your suggestion, but it seems not to work. Please see attached spreadsheet.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[philiphales]

Hi ,

See if this is OK.

Narayan

We are making progress, but this is abstracted from a programme and your method has removed the weekends, which I need.
Thanks for your help so far, but if we can leave every day in and spread the money so that it has zero in the weekends it will be there.

 

[Somendra Misra]

Hi,

Just making a small change in @NARAYANK991 Sir formula in I9 and copy across. This will also see if the date is a weekend i.e. Sat & Sun and will ignore it.

=IF(AND(I$8 >= $C9,I$8 <= $D9)*AND(WEEKDAY(I$8,2)<>6,WEEKDAY(I$8,2)<>7),$G9,0)

Regards,

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[philiphales]

Hi

This is brilliant, thanks
This will save me heaps of time and guarantee an accurate result.