Calculation that includes DATEDIF with division

[Val_Gal]

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 )
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

 

[JackDanIce]

Try

=C1/DATEDIF(TODAY(),EOMONTH(TODAY(),0),"d")

 

[Jonmo1]

# 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)