Calculate difference between two dates and flag the cell, if it is less than or equal to 30 days

[Frank Bacchus]

Hi:

I would like to calculate the number of days between two days and if the the results is less that or equal to 30 days place a "Y" in the cell. For example B1 = 10/30/2016 C1 = 03/18/2016 cell D1 should be = to "N". On the other hand, B2 = 4/5/2016 C2 = 03/18/2016 cell D1 should be = to "Y".

How can this be done? Thanks.

frank

 

[Deepak]

Is this...


=IF(B1-C1<30,"Y","N")

 

[Frank Bacchus]

Is this...


=IF(B1-C1<30,"Y","N")

Deepak:
Thanks alot. I have another value in the Cell A1. It contains "Close" or "Open" or "Monitoring" or "Transferred". I want to do the above (=IF(B1-C1<30,"Y","N")) only if the value in A1 is "Open" or "Monitoring". Is that possible?

frank

 

[skyh3ck]

try this

=IF(OR(A1="Open",A1="Monitoring"),IF(B1-C1<30,"Y","N"),"")

 

[Deepak]

Try this..

=IF(A1={"Open","Monitoring"},IF(B1-C1<30,"Y","N"),"")