Hi
I hope somebody can help me, excuse my english language...
I have 4 column that show:
First column: Date
Second column: Information
Third column: Debit
Forth column: Credit
In Date i have several date start from 1/1/07 to 3/5/07
I want to pick a value from Credit for january as 1/1/07 - 1/31/07 due to Information wich i pay rent for my home.
Something i think to use is Index and Match, but how to get it looking for just januari?
Date interval as
(Date>=1/1/07)*(Date<=1/31/07)
Is it possible to make it in Index and match?
Hope i explain well here..
Bookmarks