Calculation that includes DATEDIF with division

Val_Gal

New Member
Joined
Jun 26, 2017
Messages
11
Hello Lovely Forum Peeps!

I'm working on a 'Daily Funds In' Chart and generating fun accounting numbers based off of the daily funds in. (ACCOUNTING IS ALWAYS SO MUCH FUN!! JK, I know I only think so :-P)
My chart consists of a cell for each day laid out as the week (Sunday - Saturday) and I enter what funds have come in for the day in each cell.

I'm trying to create an equation that gives me 'Funds Needed to Generate Daily in order to Meet End-of-Month Goal'

Example: July Figures
*Data:
--Monthly Goal = $500,000 (<--number is in Cell A1, fixed#)
--Current Total of Funds In: $460,000 (<--number is in a cell B1, generated by addition equation of each daily funds in cell)
--Remaining Funds to meet goal: $40,000 (C1)
--$40,000/5days = $8,000 needed IN to meet goal
--currently I'm going in each day and adjusting the amount of days each day to get my figure, but I want excel to make that adjustment for me.

*Equation needed: take Monthly Goal and subtract out current funds in total; Divide by how many days are left in the month (including today)
*what equation I TRIED but it did not work: C1/(datedif(7/1/17-today())


I figure there's a very simple solution to this problem that I'm just missing.
any help for this novice will be much appreciated!

Val
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
# of days left in the month can be found with this

=EOMONTH(TODAY(),0)-TODAY()+1

So you can do
=C1/(EOMONTH(TODAY(),0)-TODAY()+1)
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top