I am using Excel 2016. I got a table. I want to return the corresponding date of cells that contains number (purple in colour). However, I do not need to return the date every time. It is based on the value in the column of "No of weeks". So if the no. of week is 1, return the corresponding date every consecutive cells with number. If the no. of weeks is 2, return the corresponding date every 2 consecutive cells with number. If the no. of weeks is 4, if only 3 cells with number, still return the corresponding date of the first cell. I want it to be able to return the date as shown in the sample excel.
If possible, I want to use formula to do so. If not, VBA is fine as well.
Please help me. Thank you all.
If possible, I want to use formula to do so. If not, VBA is fine as well.
Please help me. Thank you all.