+ Reply to Thread
Results 1 to 3 of 3

Counting an occupied cell with a date in the cell

  1. #1
    Registered User
    Join Date
    01-18-2014
    Location
    texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting an occupied cell with a date in the cell

    The example below shows the spreadsheet I am using. I would like to count the occupied spaces to give me a total. The spaces are a date that a service was performed and I need a total for each month.

    Tenant January February March April May June July August September October
    202G 1-Jan
    206G
    210G 14-Jan
    214 G


    Total
    Last edited by nu2tex; 01-18-2014 at 03:19 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Counting an occupied cell with a date in the cell

    Hi and welcome to the forum

    If your dates really are dates and not text that looks like a date, use =count(), else try =countA()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-18-2014
    Location
    texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Counting an occupied cell with a date in the cell

    Thanks Ford, That did the trick. Here is the formula used =COUNT(E2:E143). I appreciate your response.

+ 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. Counting Occupied cells
    By ohaganli in forum Excel General
    Replies: 6
    Last Post: 10-17-2012, 08:45 AM
  2. How can you check if the cell next to you is occupied?
    By RonaldRS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2012, 08:10 AM
  3. [SOLVED] Return a letter in another cell is occupied
    By luke.guthrie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-17-2012, 12:50 PM
  4. Auto date insert when cell is occupied
    By steve. in forum Excel General
    Replies: 4
    Last Post: 06-04-2011, 03:36 PM
  5. Replies: 2
    Last Post: 01-30-2011, 02:50 PM

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