Hello,

In column A I have dates, in column B I have variance amounts for those dates.

I want to find the most current variance from the current date that is over a certain amount and count how many days it has been since that date.

For example, the variance to locate would be greater than $50 or less than ($50)

Then it would calculate how many days have passed since the last variance of $50.

I have a attachment that lays out what I am trying to do.

Thanks for any help,

Nick

## Bookmarks