Date dependent data

**Patton** · 06-23-2019, 11:43 AM

Hello, I am wondering how I can show a different set of data depending on the date. The general idea is a weekly schedule so it would show a different data set or table depending on the week it is.

So I guess it boils down to a bunch of cells or a table if need be, that are dependent on the value of one other cell (the date).

I don't know how to do this, I thought about an if function but that would get super long really fast.

I don't want a bunch of sheets either I am trying to keep it all on one.

Thanks for the help!

**FlameRetired** · 06-23-2019, 01:05 PM

Hello Patton. Welcome to the forum.

This needs clarification.

The best remedy for that usually includes an uploaded Excel workbook representative of what you are working with and what you are wanting to achieve.

If you are not familiar with how to do that to upload directly to this forum:

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

click “Go Advanced” (next to Post Quick Reply – bottom right),
scroll down until you see “Manage Attachments”, click that,
click “Browse”.
select your file(s)
click “Upload”
click “Close window”
click “Submit Reply”

The file name will appear at the bottom of your reply.

**Patton** · 06-23-2019, 09:32 PM

Thanks for the reply, here is the attached file. Basily I want to be able to enter the date and then enter values for the various time slots, but have those be date specific, so if I enter a different date I will have a new set of values for those time slots.

**Patton** · 06-26-2019, 07:48 PM

I am trying to be able to have the various cells for the different times be dependent on another cell which is the week. So for example the week of... would have xxx values in the cells where as week... would have yyy values