Results 1 to 9 of 9

Avoid counting duplicate dates

Threaded View

  1. #1
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Avoid counting duplicate dates

    Hello friends,

    I'm tring to write a formula to count the working days in a chosen month and in the whole year based on a list with non-working days in that year.
    Everything works fine but I have a problem. If someone enters the same date more than once the foumula counts that entry too. How could I modify the formula in E2 and I2 respectively to avoid counting duplicates.

    Thank you !
    Attached Files Attached Files
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Project Dates - avoid blocked dates
    By pauldaddyadams in forum Excel General
    Replies: 12
    Last Post: 01-15-2016, 06:42 AM
  2. [SOLVED] Avoid double counting of same value
    By Karen57 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-02-2015, 09:23 AM
  3. [SOLVED] Set up avoid duplicate problem
    By aleman_li in forum Excel General
    Replies: 2
    Last Post: 04-23-2015, 10:12 AM
  4. Counting number of unique dates per month in a list of duplicate dates
    By Rackle83 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2013, 10:15 AM
  5. Excel 2007 : How to avoid duplicate entry
    By suhail in forum Excel General
    Replies: 4
    Last Post: 10-24-2010, 10:17 PM
  6. Avoid Duplicate Names
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 01:48 PM
  7. Avoid Duplicate Records
    By Amarjeet Singh in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-22-2009, 09:05 PM

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