Compare data from 2 differnt tabs and retun the differnce

[pmw19800]

Hello All

please see attached

Customer Daily data is pasted into the tabs below, Mondays on Monday, Tuesdays on Tuesday and so on…

Each day that passes the day moves to the left column and new 1 more day’s data will appear (I’ve color coded the cells to hopefully show this)

I would like a comparison of the current days data and the previous day’s data, showing what it’s increased by or decreased from the previous day

I’ve used Friday, Monday & Tuesday as examples

[JeteMc]

Perhaps this will be of some help.
1) The tab titles have been changed to text dates formatted "mdyyy"
2) The date for 'Today' has been added
3) The formula that shows the change is: =G3-INDIRECT($W$1&"!"&ADDRESS(ROW(),COLUMN()+1))
Note: the formula assumes that the parts will be in order as shown in the file attached to post #1.
4) W1 is populated using: =TEXT(WORKDAY(G2,-1),"mdyyy")
Let us know if you have any questions.

[pmw19800]

that's great, it works perfectly

[JeteMc]

Glad that it does. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.