Can someone help me out with the formula to get the payment date of an invoice
Hope someones has the answer for me
Can someone help me out with the formula to get the payment date of an invoice
Hope someones has the answer for me
Last edited by msoontiens; 10-18-2023 at 03:58 AM.
need a lot more information
vlookup() , index/match() xlookup(), filter()
functions may do this -
A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.
The forum does allow for spreadsheets to be uploaded direct to the forum -
Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Here are the instructions, found at the top of the page again
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I think I need the formula Index/Match but have never worked with that one before
ok,
well all those formulas i posted would do the same thing
vlookup , index/match do the same sort of thing, and xlookup is a later version
so as requested a sample spreadsheet , NOT images would help
I added the spreadsheet in my original request, Called Question.xlxs
Hope you can assist me as this one is driving me a little bit crazy
One example isn't a lot to go on... but:
=IFERROR(IF(A2="Sales Invoice",INDEX($C$2:$C$7,MATCH(1,INDEX(($B$2:$B$7=B2)*($E$2:$E$7="Banks")*($D$2:$D$7=D2),0),0)),""),"")
copied down????
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you all I will work on that one
Its now given me the error Opening or closing parenthesis missing
Is it OK here:
Yes that's works great, thanks so much
You're welcome. Thanks for letting us know that you got an answer.
If that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
Another question
I am looking for a formula in Column R that when invoice ( Inkoop factuur see column G) is also in a line with mentioning column S "1010 - bank " then the cell should mention Paid if not then Open
Is there someone who can help me with this one see enclosed example
First need to clear the data validation from cells R2:R5
Next paste the following into cell R2 double click the fill handle to copy down:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks