Hi

I have several different values for every day of the year (I called this the long sheet) columns as follows

today's date ---- value a ---- value b --- value c

Making a graph of this all isn't helpful. It doesn't show the level of detail I need.

I am more interested in +/- 28 days from today.(I call this the focus sheet)

How can I find today's value and pull out the corresponding values a/b/c from the long sheet and out them on the focus sheet?

Many thanks