I have an excel workbook. Cell A1 is a fixed value with today’s date and the rest of the cells are populated with a formula (=A1+1, =A2+1). The dates are not recognised by read range workbook because they are populated by a formula.
I want to store it into a datatable so that i can filter by date.
Can someone please advise ?