What ‘IF’ statement can I create to put ‘0’ when a column date is past today’s date. Example:
Calculate the # of Days prior to Lease Expiration but do not calculate if the Expiration Date is past today
We have a board for all of our tenants past and present and do not need this calculated in the group of ‘Past Tenants’, though want it calculated in the group of ‘Current Tenants’, Here is the formula we want to nest into our IF Statement:
Appreciate your help!