Formula to Calculate only if Date of Column is Before Today

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:

ROUND(DAYS({Lease Expiration},TODAY()),0,0)

Appreciate your help!

@turnkey24,

With what you’ve given, you don’t need an IF statement. Try this:

MAX(ROUND(DAYS({Date},TODAY()),0),0)
1 Like

We need a new title here in the community for you, @JCorrell! Something like “Formula Master”, lol.

1 Like

You are awesome and thank you very much!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.