Occasional Visitor

Hello everybody! I have a table with daily cash values that I make a day at the place where I work and another table with the store's monthly goal. I made a formula to give me the daily goal, but now I need a formula that tells me what amount I should do to reach the monthly goal, minus the daily amounts added.

1 Reply



Without knowing how you've laid out your own spreadsheet, I had to make some guesses as to how I might do this. I came up with the attached sheet. Here's an image, but you can download the actual spreadsheet below.