Hi I'm hoping someone can help,
As you can see I have a range of dates in A1:A10
These dates have a corresponding set of values in B1:B10
Where the text is red (call it D5), I would like to output the value in the B column, corresponding to when the date in the A column is todays date
For example if the date were 05/04/2019 the output shows 4345
Bookmarks