Forum Discussion
How to search in a table with multiple dates and criteria in Excel
Hi. Good day everyone. I am having a problem to like to automatically check if I already have paid a utility bills in its due date on my Budget table. Have to Table one for my credit debit transac...
That could be like
=IF( SUMPRODUCT(
(MONTH(<DATE column>)=<month>)*
NOT(ISBLANK(<IF PAID column>))*
(<DESCRIPTION column>=<Description value in row>)
),1,"")assuming all dated are in one year. Otherwise instead of Jan, Feb, etc. is to use any date within the month formatted as mmm, and SUMIFS similar to above using EOMONTH to check if paid data is within the month.
Perhaps on sample file it'll be easier to explain.
Thank you and it did well but my other issue is that at my example even though my due date is on Feb but I paid it before and the date is Jan.31 so I kind of looking like within its due date range from DUE DATE -10 to DUE DATE +10
EX to add in formula
=IF ( AND ( DUEDATE - 10 >= DATE, DUEDATE +5 <= DATE),1,"")
