What would be the most direct way to determine if the date of a cell matches the month and date of another cell?
For example, cell A1 = 10/12/18 and I need an if statement to compare its date to a row showing various months and years - b1 = 10/17, c1 = 10/18, d1 = 10/19
Thus, need an If statement to return a result of c1.
Thanks
For example, cell A1 = 10/12/18 and I need an if statement to compare its date to a row showing various months and years - b1 = 10/17, c1 = 10/18, d1 = 10/19
Thus, need an If statement to return a result of c1.
Thanks