IF({Client Payment Date}>=11, AND({Client Payment Date}<=20,“25th”))

This is what I have so far, but it’s displaying a 0 or a zero in the “Payment Transfer Date” column.

Zero or a 1 is what I meant to say above.

Welcome to the community, @Andrew_Strotheide! :grinning_face_with_big_eyes: When trying to find where something falls in a sequence, you can also work the comparisons in sequence—either highest to lowest, or lowest to highest—and you don’t need to use AND() anywhere in the mix. (Your use of AND is also malformed, but I’ll get to that later).

To start with the lowest range first, it would be structured like this:

IF({Client Payment Date} < 11, "15th", IF({Client Payment Date} < 21, "25th", "5th"))

To break this down, we first check to see if it’s less than 11, meaning anywhere between 1 and 10. If that is true, we know we want to output “15th”, and the rest of the comparisons are skipped. If not, moving to the next comparison and checking for a value less than 21 effectively means it must be between 11 and 20 because the first comparison failed. If that’s true, we output “25th”. If not, only possible option is that it’s 21 or higher, so we automatically output “5th”.

To work from the other end, it would be structured like this:

IF({Client Payment Date} > 20, "5th", IF({Client Payment Date} > 10, "25th", "15th"))

Either way, this is your output:

Now, for situations where you need to use AND(), you put all comparisons inside the AND() function, like this (random example not related to your use case):

IF(AND(Color="Blue", Value=10), "Blue 10", "Something else")