Hi,
I am a beginner/moderate user of Excel and I'm having difficulty solving this issue. Can someone help identify if there is a formula I can use to do this?
I have a list of ID numbers in column A. I have a list of consecutive dates in row 1. I need to populate the ID number periodically in the correct date column based on a frequency, leaving all non-applicable dates blank.
For example:
ID # A123 should populate every 7 days, weekly. The first date is 11/10/17. Therefore, I want it to populate ONLY in every seventh date - 11/17, 11/24, 12/1, and so on, with the rest of the columns blank for that row. Is there a formula that can do this?
excel help example.PNG
I filled in the first example manually, but there has to be a way to get this populate automatically. I also have no clue how to get a "twice a week" frequency to generate, especially if the dates are different. One could be Monday/Thursday, another could be Tuesday/Friday. After the formulas are set up and plugged in, I want to be able to scroll down through the list to see which ID#s fall on a particular day, say 11/17. Is this even possible? Is there another way to do this that would be easier or more straightforward?
I appreciate the help.
Thanks!
Bookmarks