Extract from dataset

**joshua1990** · 10-03-2017, 11:33 AM

Hey guys!

The big goal is to create a graph which always represents the last 20 working days.
This is probably a major problem. I have already mentioned this topic and I hope now for further and new ideas.
http://www.vbaexpress.com/forum/show...namic-diagramm

I would like to create a table, which represents me only the last 20 working days.
In the first column is the date, in the second the status, and in column 3-5 the individual values.

Last line: Current date (If workday)
Penultimate line: Current date -1 (If Workday)

Is it now possible to create such a table in order to build up the diagram?

Best regards!

**6StringJazzer** · 10-03-2017, 12:07 PM

In the first column is the date, in the second the status, and in column 3-5 the individual values.

That's not what your file looks like but I'll try to imagine it.

You do not mention holidays so this assumes that Monday-Friday are always the working days.

The last date is today, or the next working day if today is not a working day. This is done by looking at what day of the week the day is and adjusting to Monday if it falls on a Saturday or Sunday.

The other values used the WORKDAY function to move backwards one working day.

Then there are VLOOKUPS to pull out the data.

**joshua1990** · 10-03-2017, 12:11 PM

Originally Posted by 6StringJazzer

You do not mention holidays so this assumes that Monday-Friday are always the working days.

Hey, thanks for your approach!
Of course, there a also holidays but currently not defined.
The second colum (Status, Workday-Status) defines this. There are some weekends as workdays but currently not updated/ defined as workdays.
Its possible, that special days will be defined als work or not-workdays during the year.