Hi All,
I am looking for a formula which will do the following.
I have two columns
columnA: invoice receipt date
columnB: Invoice Base Date.
I want to find out how many time does the invoice receipt date - invoice base date = to some values.
eg. for invoice 1 i might have both dates equal but for invoice 2 there are 5 day difference. I also have a problem that because of system error, some field in invoice receive date are missing, so i will just ignore them and count for those which is not blank.
I have a table with numbers 0 to 20 which is the number of days they are difference by.
This formula is what I am trying to build on, I dont think this is right since its not giving me the right answer at all
={COUNT((IF((InvoiceReceiveDate-InvoiceBaseDate)=C11,1)*IF(InvoiceReceiveDate<>"",InvoiceReceiveDate))}
Hope you guys could help me out!
I am looking for a formula which will do the following.
I have two columns
columnA: invoice receipt date
columnB: Invoice Base Date.
I want to find out how many time does the invoice receipt date - invoice base date = to some values.
eg. for invoice 1 i might have both dates equal but for invoice 2 there are 5 day difference. I also have a problem that because of system error, some field in invoice receive date are missing, so i will just ignore them and count for those which is not blank.
I have a table with numbers 0 to 20 which is the number of days they are difference by.
This formula is what I am trying to build on, I dont think this is right since its not giving me the right answer at all
={COUNT((IF((InvoiceReceiveDate-InvoiceBaseDate)=C11,1)*IF(InvoiceReceiveDate<>"",InvoiceReceiveDate))}
Hope you guys could help me out!