I currently have this array formula:
[/FORMULA]Formula:
Please Login or Register to view this content.
This works perfectly but I want to add a condition that column N in the 'DROP CLIENT FCI HERE' which is a Payment Date, the month, must equal today's month in order to return a result. I tried adding it as an AND on the last IF condition but it didnt work.
Any help would be much appreciated!!!
Thank you so much in advance!
Alex
Try this:If it doesn't work please upload as small of a sample file as possible so that we can test possible solutions on your layout.Formula:Please Login or Register to view this content.
To attach a sample workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
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.
Hi JeteMc,
Thats fantastic, it worked perfectly!! Thank you so much!!!
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks