Looking to compare two dates to create an Integer value across sheets

Sebastian Costello

Hello,

I am looking to create a tracker that tells me the quantity of samples that arrived in the estimated time against the actual time. My thought process was you have two date columns Date Column A (estimated date) and Date Column B (actual date). I would in my raw data sheet create a link to Column B first than compare that to Column A, if the difference was a positive integer it would count as 1. And the formula would run for all of the product families with sample orders.

The formula I made looked like this

=COUNTIFS({SHEET1 DATE COLUMN B}<{SHEET1 DATE COLUMN A}, 1)

I did not want to have this count in the same sheet as the date data as the sheet is already quite large and I want to reduce redundant information. This data will eventually end up in a graph anyways so its really just a feeder middle sheet that this formula will be used in.

I hope I made my problem easy to understand, if not I am happy to try to clarify more.

Thank you for any help!

Sebastian,

Paul Newcome

It would need to be calculated on the sheet containing the dates. You can then use a second sheet or row report to create a summary of those rows, but the initial calculation would need to happen on the source sheet.

Paul Newcome

It would need to be calculated on the sheet containing the dates. You can then use a second sheet or row report to create a summary of those rows, but the initial calculation would need to happen on the source sheet.

Sebastian Costello

Thank you Paul, this worked for me.

Paul Newcome

Happy to help. 👍️