I’m very grateful to the member who helped answer my last question. I have another one.
Two cells
A1: a beginning date
A2: an ending date
I need cells a3 through a30 to populate a specific number that corresponds to the beginning date and any dates 14 days in between the beginning date and ending date.
Example:
A1: 01/01/2000 A2: 01/01/2001
A3: 1001 B3: 01/01/2000
A4: 1010 B4: 01/15/2000
The number in cell A3 will be from a vlookup and will correspond with the number on B3. The key is that each cell between a3:b40 needs to be auto-populated with numbers based on the input of a1, a2. If there are not enough numbers between cells a1:a2 to fill all forty cells, then it just stops at the last date (a2).
I hope I am being clear enough with this. I thought about attaching an .xlxs document but I am not able to do so from my current location.
Bookmarks