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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to calculate sales tax from total sales 7
Calculate MTD and YTD in a query 8
How do I calculate a specific formula for price increases? 3
calculate shipping costs in excel 2007 2
summing total sales formula 1
How can I use a formula to calculate a running sub-total in excel 2
How do I calculate Amount of Sales Tax from Total Amount? 1
My formulas do not calculate in some Excel applications - help! 1

Top