How to calculate amount for each working day

[misbell23]

I am trying to figure out how to get an amount & divide it by Day 1, then Day 2, then Day 3 etc. In the example attached I have to manually take the $2,111,588.44 & divide by 19 to get 111K (111,136.23 rounded up).
The Daily Actual /19 column starts of as 1, then goes 2,3,4,5 etc.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[misbell23]

I have attached an Excel formula for what I am needing

[Beamernsw]

Hi misbell23, I think you need to add a little more info. I guessed that the date in A3 might change and that is what the formula needs to work on...the 1 then 2 then 3 etc.
So I added a formula to cell B3 to calculate how many working days (banking days) there are to date from the 1st of the month.
Then I assumed that G3 was simply 1 less then that....so B3-1
Then I added the dividing formula to G4 and copied down (with a custom format to match what you had).

I know I guessed and assumed much, so hopefully something here might help get you started at least.



Edit: Added in holidays (Australian - just as an example)