Hi,
I am really struggling with combinding a search for multiple matches and one of them includes finding the nearest date. Please have a look at the attached excel sheet to see if you can help :s
many thanks
Hi,
I am really struggling with combinding a search for multiple matches and one of them includes finding the nearest date. Please have a look at the attached excel sheet to see if you can help :s
many thanks
Hi fordieuk,
Try using below formula:-
Formula:Please Login or Register to view this content.
Enter above formula using ctrl shift enter key combination.. thanks.
See attached:- payment forms example 1.xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
DILIPandey,
Thanks for your help, it doesnt quiet cover what I was after. The received date cant exceed the application date but has to be between the previous application date and the next one in line with the PS i.e. 60 or 30 etc if that makes sense.
In your template if I put a received date of 20/1/13 it returns 6/1/13 with is 14 days after the application date and the latest the application is meant to be submitted.
Can you suggest anything else to prevent the above from happening?
Kind regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks