Counting leasing dates that will expire in 30/60/90 days

    I have a column of lease expiration dates entered manually in short form date "1/1/2011". I am having trouble building a function that can look through the column and count what leases will expire in the next 30/60/90 days. Thank you in advance!

    Re: Counting leasing dates that will expire in 30/60/90 days


    I would have the =TODAY() somewhere in your worksheet lets say Cell A1
    Lets also say your lease expiration date is in cell B1
    Then add another column to what you already have lets say in C1. Put the formula =SUM(A1-B1) into cell C1 and change the cell format to number. use a countif formula to find where cell c1 hold 30, 60 or 90.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login