Closed Thread
Results 1 to 4 of 4

Count a different date on a cell,based on date month and year

  1. #1
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Wink Count a different date on a cell,based on date month and year

    Hello,,

    I need to count number of date in a cells, but I just want to count it as a one if there is a same date in a cell.

    Is there any formula to fix it. Thank you


    I already attachh the example.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,914

    Re: Count a different date on a cell,based on date month and year

    Have you tested the array formula in this post #10?

    https://www.excelforum.com/excel-for...ml#post5845363

  3. #3
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Count a different date on a cell,based on date month and year

    Indeed it is.. Thanks,,

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,938

    Re: Count a different date on a cell,based on date month and year

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ear-exist.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extracting Date (year,month,day) from cell with Date (year,month,day,time)
    By TheRobsterUK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2020, 01:58 PM
  2. Replies: 1
    Last Post: 02-28-2020, 04:15 AM
  3. Replies: 3
    Last Post: 06-26-2019, 11:46 AM
  4. [SOLVED] Count cell only if date matches current month & year
    By SadOfficeWorker in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-14-2016, 02:51 AM
  5. Need to convert Month/Date/Year to Year/Month/Date so excel will recognize
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2014, 04:17 PM
  6. [SOLVED] count if date in another cell falls in certain month and year
    By ea223 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-18-2012, 07:17 PM
  7. Replies: 1
    Last Post: 08-13-2012, 11:18 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