Conditional Formula Help

[fishin]

In need of a conditional statement that addresses the requirement below.


If the result of subtracting today’s date from the date posted in J221 is greater than 180 but less than 366, return the result to the targeted recipient cell, otherwise the targeted recipient cell is to remain blank.

 

[MrKowz]

Try:

=IF(AND(J221-TODAY()>180,J221-TODAY()<366),J221-TODAY(),"")

 

[VoG]

Tty

=IF(AND(J221-TODAY()>180,J221-TODAY()<366),J221-TODAY(),"")

 

[fishin]

Thanks for your quick response. You responded with:
=IF(AND(J221-TODAY()>180,J221-TODAY()<366),J221-TODAY(),"")

My initial request for a conditional statement was:
Follow-Up Request(s):

"If the result of subtracting today’s date from the date posted in J221 is equal to or greater than 0 but less than 91, return the result to the targeted recipient cell, otherwise the targeted recipient cell is to remain blank."

"If the result of subtracting today’s date from the date posted in J221 is less than 0, return the result to the targeted recipient cell as a positive number, otherwise the targeted recipient cell is to remain blank."

 

[VoG]

Try

=IF(AND(J221-TODAY()>=0,J221-TODAY()<91),J221-TODAY(),IF(J221-TODAY()<0,TODAY()-J221,""))

 

[fishin]

Thanks again for the response, but I actually need two individual conditional statements. The one provided, =IF(AND(J221-TODAY()>=0,J221-TODAY()<91),J221-TODAY(),IF(J221-TODAY()<0,TODAY()-J221,"")) is sort of a blend between the two issues I attempted to address in my post as follows:

Would you please respond again?

"If the result of subtracting today’s date from the date posted in J221 is equal to or greater than 0 but less than 91, return the result to the targeted recipient cell, otherwise the targeted recipient cell is to remain blank."

"If the result of subtracting today’s date from the date posted in J221 is less than 0, return the result to the targeted recipient cell as a positive number, otherwise the targeted recipient cell is to remain blank."

 

[VoG]

"If the result of subtracting today’s date from the date posted in J221 is equal to or greater than 0 but less than 91, return the result to the targeted recipient cell, otherwise the targeted recipient cell is to remain blank."

"If the result of subtracting today’s date from the date posted in J221 is less than 0, return the result to the targeted recipient cell as a positive number, otherwise the targeted recipient cell is to remain blank."

Doesn't it do that?

 

[MrKowz]

To cover all three scenarios you have provided:

1. If the result of subtracting today’s date from the date posted in J221 is greater than 180 but less than 366, return the result to the targeted recipient cell, otherwise the targeted recipient cell is to remain blank.

   =IF(AND(J221-TODAY()>180,J221-TODAY()<366),J221-TODAY(),"")

2. "If the result of subtracting today’s date from the date posted in J221 is equal to or greater than 0 but less than 91, return the result to the targeted recipient cell, otherwise the targeted recipient cell is to remain blank."

   =IF(AND(J221-TODAY()>0,J221-TODAY()<91),J221-TODAY(),"")

3. "If the result of subtracting today’s date from the date posted in J221 is less than 0, return the result to the targeted recipient cell as a positive number, otherwise the targeted recipient cell is to remain blank."

   =IF(J221-TODAY()<0,TODAY()-J221,"")

 

[fishin]

Thanks....Number 3. is perfect.....Number 2 is ever so close. I believe what I missed relative to number 2. was to state that if the difference between todays date and the date posted in J221 was 0 (zero), in other words, the dates were the same, then in addition to the values 1 thru 90, I also want the value 0 (zero) to post in the recipient cell when that is the case.

 

[MrKowz]

Then for scenario 2:

=IF(AND(J221-TODAY()>=0,J221-TODAY()<91),J221-TODAY(),"")