Help - how to find and minus today's data from yesterday's data

[Beans86]

Hi,
I am trying to create a formula, but my knowledge of excel formulas is very new! I am trying do create an excel formula which calculates the difference in video view data which I enter, comparing today to yesterday to see the growth.

My column A is dates. My column B is video data.

Is there a way Excel can work out the TODAY date's data and minus YESTERDAY date's data to find the growth?

My thinking is that this would look something like the following, but I'm not sure how it would be written in Excel's formua:

Where Column A is = TODAY (), conduct sum where TODAY () minus data from yesterday (TODAY () -1).

-Find TODAY ()
- FInd TODAY'S associated data
- Find YESTERDAY or TODAY -1
- FInd YESTERDAY'S associated data
- Minus Yesterday from Today to find the difference.

Anyone have any ideas?

Much help would be appreciated!

Cheers
Beans.

[gmsninja]

Hi,
Can you post an example of your sheet?

[Beans86]

Calculations v1.xlsx

I have attached the spreadsheet here.
I haven't put the calculations in because I'm not sure how to do it!

[gmsninja]

Hi Beans,
solution attached,
I moved your overnight growth to a different column so you can use the formula as your data gets bigger.Calculations v1.xlsx

[Beans86]

Thank you! This is brilliant! Much appreciated!!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.