+ Reply to Thread
Results 1 to 2 of 2

evaluate range of dates for total same month occurences

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    Olive Branch, Mississippi
    MS-Off Ver
    Excel 2003
    Posts
    2

    evaluate range of dates for total same month occurences

    Hi- new member here...I could use some help on the following issue:

    I have a column of dates in 00/00/0000 format, representing the expiration dates for all leases in an apartment complex (shown on 'Expiration Date' tab on the attached file). The 'years' in this column range from 2010-2013. On a separate worksheet (shown on the 'Leases Expiring by Month' tab), I'd like to return the total number of leases that expire in each month of this range of years. For example, there are a total of two leases expiring in November of 2012. I have hand entered '2' on the worksheet to indicate the intent for the formula outcome. How can I accomplish this?

    Thanks so much in advance....
    Lease Maturity Schedule.xlsx

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: evaluate range of dates for total same month occurences

    Put this formula in B2 of the summary sheet:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    then copy across and down to fill your table.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1