Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

# Excel 2010 formula question

2 replies to this topic

### #1 Geoff777

Geoff777

• Members
• 244 posts
• OFFLINE
•
• Gender:Male
• Location:England
• Local time:04:30 PM

Posted 23 July 2018 - 04:07 AM

Hi

I am trying to compare 2 columns of dates A and B. I want to show TRUE in column C if the dates are within 90 days of each other.

Any suggestion welcome.

Many thanks

Geoff

Geoff

### #2 Geoff777

Geoff777
• Topic Starter

• Members
• 244 posts
• OFFLINE
•
• Gender:Male
• Location:England
• Local time:04:30 PM

Posted 23 July 2018 - 06:26 AM

Sorted thanks!

=AND(A6-B6<=90,A6-B6>=90) Assuming your dates start in row 6.

Geoff

### #3 Cynthia Moore

Cynthia Moore

• Members
• 300 posts
• OFFLINE
•
• Gender:Not Telling
• Local time:08:30 AM

Posted 03 August 2018 - 02:09 AM

It would be helpful if you posted some sample data.

Here's a solution if your data looks like this:

R/C      A           B        C      D          E

5     Date1       Date2    Diff    <=90?    Formula

6    08/03/18    08/03/18    0     TRUE   F6:  =ABS(D6-C6)<=90

7    08/03/18    08/04/18    1     TRUE   F7:  =ABS(D7-C7)<=90

8    08/03/18    08/02/18    -1    TRUE   F8:  =ABS(D8-C8)<=90

9    08/03/18    10/31/18    89    TRUE   F9:  =ABS(D9-C9)<=90

10    08/03/18    05/06/18    -89   TRUE   F10: =ABS(D10-C10)<=90

11    08/03/18    11/01/18    90    TRUE   F11: =ABS(D11-C11)<=90

12    08/03/18    05/05/18    -90   TRUE   F12: =ABS(D12-C12)<=90

13    08/03/18    11/02/18    91    FALSE  F13: =ABS(D13-C13)<=90

14    08/03/18    05/04/18    -91   FALSE  F14: =ABS(D14-C14)<=90

Running Win 10 & Office 365.

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users