Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
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.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel 2010 formula question


  • Please log in to reply
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

BC AdBot (Login to Remove)

 


#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