Extract data between two dates

**Tarentum** · 02-28-2017, 03:01 PM

Hello Everyone,

Suddenly I received a task from my boss, with a very short deadline. I’ve spent two days in agony with this, so I decided to ask for help

I would highly appreciate if you could help solve the below issue. The story goes like this:

There is a shift plan, where we need to mark our holidays, sick leave..etc. This is used for planning… BUT! Every time when we need a holiday, we need to request it in a tool, and that tool also generates the report. This report marks:

- The name of the requester
- Request type (Sickness, Holiday..etc.)
- Starting date
- Ending date

Now…. In a lot of occasions, this report differs from the shiftplan. For this reason, my Boss decided to give me like 400 requests to compare it with the shift-plan

Example attached:

https://www.dropbox.com/s/ogsa340x1f...ample.xls?dl=0

Question is… How can I tell my formula, to check a specific person’s schedule for a specific date range..? If shift-plan and report is in sync, I don’t need to do anything… But, if there is a mismatch, I need to mark it on a new spreadsheet:
Name of the requester; Request type; Starting date; Ending date; Actual markings in shift-plan for the related range.

Any idea is appreciated!!!

P.s. We use Office 2010

Kind regards,
Norbert

**philaugust2004** · 02-28-2017, 05:37 PM

I think you will need VBA for this

**dflak** · 02-28-2017, 05:48 PM

I can't open the dropbox, could you attach it here? If it's big, compress it and attach it as a zip file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.