Asking a ? in a formula

[MInConst]

I have a worksheet for my wife that she needs to fill out weekly for work. It contains 3 cells that I want to automate. My problem is that some of the date required changes at times. I will explain.
One cell needs this.. (Daily Goal Quota) = "Remaining monthly goal ÷ # of days left in the month."
The remaining monthly goal is derived by subtracting a changeable goal - what she has done to date which is in another cell already. She gets this from a printout. So the changeable goal needs to be input into this formula as a question.
Another cell needs.."Daily Goal Quota x days in that week"
The Daily Goal Quota is now a known from above but the days left in the week changes hence a question in the formula.
So my question is.. Is it possible to add a question to a formula? Like when she gets to the cell a pop up, or something, comes onscreen and asks her for the quota or days left in the week as needed.
I hope I've made this understandable. Thank you for your help.

 

[scottylad2]

I cant see the need for a week to date cell. If as you say your weekdays run from sun through Sat, thats 7 days so in essences its a running total for the month you need not a weekly one? When you try and introduce weeks, then part weeks come into play (this month we would be having a part week at the start and end of the month, with 4 full weeks in between!)

So i'd just have an input cell for your monthly target divided by the number of days in the month. $1000/31 would give you a daily target somewhere near to $34 this month and 35 in Feb. Build a table with your dates and target for each date on a separate sheet, and on your front sheet you can have a cell display the running total both as a cash return and a percentage of the monthly target achieved.

You can do your division of days per month against real dates by uing things like =Today to get a date in 1 cell, =Day(Eomonth(Today),0)) will get you the number of days in this month (whatever month you happen to be on )
=DAY(TODAY()) will tell you what day in the month this is in a number form......todays shows 9

a sum of =Day(Eomonth(Today),0))-Day(Today()) will let you see how many days of the month you have left. And these formulas will adjust each day, as the Today function will be relevant to whatever day you open it. I could do a table for you based on what i've just said, but if you need everything to happen from only 3 cells on your front page then you need one of the VBA gurus to help