Forum Discussion
show a due date using data from multiple columns
I have a spreadsheet in which I have multiple date values - a client's birthday, follow up visit date 1, date 2, date 3. for each date column I have conditional formatting set up to mark the cell yel...
=IF(OR(AND(M16-TODAY()>0, M16-TODAY()<30), AND(N16-TODAY()>0, N16-TODAY()<30), AND(T16-TODAY()>0, T16-TODAY()<30), AND(V16-TODAY()>0, V16-TODAY()<30), AND(X16-TODAY()>0, X16-TODAY()<30), AND(Z16-TODAY()>0, Z16-TODAY()<30)), "Due", "Up to Date")