+ Reply to Thread
Results 1 to 5 of 5

Count Day and year

  1. #1
    Registered User
    Join Date
    12-13-2014
    Location
    Denver, CO
    MS-Off Ver
    2013
    Posts
    10

    Count Day and year

    I've got a worksheet that I am trying to get it to count months and years and put it in multiple other sheets. I want my employees to put in the information in the Tracking and it count from the Move in date how many were received by the month and by the year in the Lease Count. Then I want the lease count to fill in the lease expiration by it's move in date and lease term. For instance, if someone does a 12 month lease and moves in on 1/1/17, I want it to increase the the January 2017 count by 1, and add 1 to the December 2017 (because it would expire 12/31/17) on the lease expiration.

    Am I asking too much?

    I have it calculating days in the apartment, as well as cells that find the text from the dates so it can find just the month and just the year for both move in and move out date.

    I think I've been looking at this too long.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-30-2015
    Location
    Netherlands
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    145

    Re: Count Day and year

    Hi,

    You were close but just missed the mark on a few things.
    Take a look and see if this is what your after.
    HtH,

    Joris

    --------------------------------------------------------------------------------
    If you found my answer helpful, please hit the Like or Thank button.

    Please follow the forum Rules and Guidelines and use Code tags around your VBA code.

    Remember: test VBA code always on a copy of your file because usually you can't use undo

  3. #3
    Registered User
    Join Date
    12-13-2014
    Location
    Denver, CO
    MS-Off Ver
    2013
    Posts
    10

    Re: Count Day and year

    It's close, but right now that is counting the lease expiration in the lease count too. I want new leases to be on the lease count via the Move In Date on the New Leases Tab, and the lease expiration to count from the move out date. But I don't want the lease count to count the move out date or the lease expiration to count the move in date.

    I appreciate the help. Thank you!

  4. #4
    Registered User
    Join Date
    12-13-2014
    Location
    Denver, CO
    MS-Off Ver
    2013
    Posts
    10

    Re: Count Day and year

    Also, it is not finding it by the year. If I put in another to include 1/1/2020, it take the January count up to 3 on 2017, 2018, and 2020

  5. #5
    Registered User
    Join Date
    12-13-2014
    Location
    Denver, CO
    MS-Off Ver
    2013
    Posts
    10

    Re: Count Day and year

    After playing with the =DATE function and deleting the end part of the function on the lease count, I think we've got it!

    Thank you SO much for all your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] countifs to find the total count between this year and last year for series of data
    By maher2014 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2016, 02:39 AM
  2. [SOLVED] Count and Sum for the given month and year
    By Sekars in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-20-2016, 09:50 PM
  3. Replies: 2
    Last Post: 11-18-2013, 12:22 PM
  4. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  5. [SOLVED] Count/No Count for year entered---formula help
    By awest181 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-26-2012, 02:07 PM
  6. [SOLVED] Count days for specific year falling within in multi-year date range
    By jslo2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2012, 05:58 PM
  7. [SOLVED] Is it possible to count the day of Month/Year?
    By Joe in forum Excel General
    Replies: 1
    Last Post: 03-18-2006, 05:20 AM

Tags for this Thread

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