Formula To Identify If Cell Dates Occur Within 30 Days of Adjacent Cell Date

[eagerexceler]

Hello y'all,

I've got a simple formula to identify if a date in W4 occurs within 30 days of a date within X4: =IF(W4+30>X4,"Readmission Present", "No Readmission").

I'm trying to expand the formula to have it include this date comparison for the next 24 rows. As in, also including IF(X4+30>Y4.... and so on, all the way to AU4. I know I can do this with a crazy nested formula, but I'm wondering if anyone has any insight into making this a simpler formula.

Thank you!

 

[eagerexceler]

Just wanted to point out that I posted a new thread as "Formula to identify if a common account number has a corresponding date within range of another date, just in case y'all have any other magic to share with me