Removing a returned value of FALSE in Excel

 Blocked Profile -

Here is my formula. Please tell me how I can eliminate the FALSE value for cells that don't fall within the date range (e.g. cells with dates that start prior to the date listed in EF13).


1 reply

Ok, well you have nested ifs, and didn't give the second false statment. Consider your example:

Now take a look at this:

I hope that helps!
It's kind of fun to do the impossible! -Walter Elias Disney