Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
skcaton
 
Posts: n/a
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate sales run rate LoriM Excel Discussion (Misc queries) 2 May 4th 23 07:47 PM
formula to calculate sales tax from total sales Deanna Excel Worksheet Functions 7 October 5th 05 08:57 PM
How to sum total automatically in more than one sales invoices Dr.H.Subramanian Excel Worksheet Functions 1 May 23rd 05 10:44 AM
How do I calculate Amount of Sales Tax from Total Amount? MikeS Excel Worksheet Functions 1 March 26th 05 07:49 PM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"