find exact or immediate inferior date

Hi everybody!

Second post here, i think i need some help..

I have a sheet that many users use to create TASK for vehicles. Those task should be created in order of "Starting date of the task".

I've been able to find and create the task template under a task with the SAME date, i can't find a way to select the closest inferior date…

Here's the code i use to find the SAME date:

Please Login or Register  to view this content.

Tâches.png

Let's say a user create a task that would start the 29/10/2020, i need to create that task in between the task that start the 28/10/2020 and the one that start the 02/11/2020.

Anybody has an idea to get the immediate inferior date (if the exact one doesn't exist) ?

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Try it again. It does not seem that you have done this correctly. Highlight your code in Edit mode and then click on the # sign.