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.

 

[fishin]

That did it! Thanks again....greatly appreciated!

 

[fishin]

One more time please?

The conditional statement provided below does indeed work. However, I missed one condition, that being that when J221 is blank, I want the recipient cell to remain blank.

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

 

[VoG]

Try

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

 

[fishin]

Again??


If the date posted in J231 minus today is equal to 0 (zero), then post the result 0 (zero), in the recipient cell ....if cell J231 is blank the recipient cell is to remain blank

 

[VoG]

You have been given numerous replies to this thread and based upon those you should be able to devise your own formula(s).