How to adjust data date range based on analysis range

Hi,

I'm putting together a spread sheet to analyse sets of equipment downtime data. The data is entered into access database. To analyse, the spread sheet is loaded. The user enters in two dates, start and finish for the date range they want to analyse. The spread sheed automatically updates the data from the database through links. I got that all working nicely.
However I have a challenge. For example, some of the downtime events might have started before the user defined start date but finished after the user date. As such I would want to correct the list of entries to adjust the entries that have the start time before the user defined date, and change it to the user defined date.
I hope that makes sense. In all, there are 6 types of date ranges that have to be adjusted. See attached image for the types.


Date Range Types.jpg - not a worksheet picture but a date range possibilities


I was thinking of using If functions to achieve this.
Is there a neater way of doing this in excel keeping in mind that I don't want the user to enter anything else for the analysis except the start and finish dates for the analysis cycle?

As requested per the rules, attached is the spread sheet. I hope you can open it with data in it, since it is pulling data from our network....
Downtime Data Analysis.xlsx

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)