How can I count dates in the past/future?

05/27/20 Edited 05/27/20


I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are in the past. In this case, the counter should return 2 dates in the past and 1 date in the future.

Any help is appreciated! Thanks so much in advance

Best Answer


Sign In or Register to comment.