Forum Discussion
Solved
formula that finds closest future date to today's date
Hi all, I'm looking for a formula that looks in a Table's column (Contract Due Date), and finds the closest future date to today's current date so I can set up a graph that automatically shows th...
Let's say you enter the formula in K2.
=SMALL(IF(Table3[Contract Due Date (BaseLine)]>TODAY(),Table3[Contract Due Date (BaseLine)]),ROW(K2)ROW($K$2)+1)
Fill down.
Let's say you enter the formula in K2.
=SMALL(IF(Table3[Contract Due Date (BaseLine)]>TODAY(),Table3[Contract Due Date (BaseLine)]),ROW(K2)ROW($K$2)+1)
Fill down.