How do I calculate a MTD total - yesterdays sales in Excel?
 

I need to set up a formula that calculates the MTD total less yesterday's
sales in Excel. My current formula is a basic calculation of the daily input.
The supervisor wants to be able to see that each store is updating the
individual spreadsheet daily. If there is not a way to calculate this, I am
open to suggestions of alternative solutions.