Aging report formula not working for 0-30 days past due

I am so new to using excel that I hope if what I am asking make sense since I don't know all of the lingo. I have created an insurance claim aging report. The columns for 31-60 days, 61-90 days and over 90 days columns are working fine and calculating how they should be. However, for some reason, I can't figure out the 0-30 day column. I will post the formula that I used for the 31-60 day column.

=IF(AND($F6>=31,$F6<=60),$E6,"")

Can anyone tell me how to do the 0-30 day column?

Let me know if this is not enough info in order to help me.

Thanks in advance for any advice given.

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Originally Posted by Lorir1

I tried that formula and it didn't work.....

See post #3

Yes, thanks.

The problem is actually with the formula in F6
=IF($C$3-D6>30, $C$3-D6,"0")

That "0" is actually being considered a TEXT string because of the quote marks, it's not really a number.
So the > and < comparisons used in the AND function are don't consider it a number, therefor it's NOT between 0 and 30.

Try removinging those quote marks from the 0 in that formula.
Then the and function will work as expected.


And considering the logic of the formula in F6, the result will NEVER be 1 to 30, only 0 or 31+.
You can get away with
=IF($F6=0,$E6,"")