Monday, October 12, 2015

Excel Functions

=COUNTIF(J2:J2,"<"&TODAY()-7)
Where J2 is the Created Date. From the example above:

  • If the Created Date is later than 7 days, then the Excel function will return as a Red column and with value 1. 
  • If the Created Date is less than 7 days, then the Excel function will return as a Green column and with value 0.

No comments:

Post a Comment