Results 1 to 4 of 4

Highlight Dates Excluding Times that are different

Threaded View

  1. 05-30-2023, 10:04 PM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    Highlight Dates Excluding Times that are different

    I have dates in Col B. I have triedc to use a CF formula below to highlight the Dates that are not the same excluding times

    In this example B2 is different, but is not being highlighted

     =COUNTIF($B$1:$B$100, DATEVALUE(TEXT(B1,"dd/mm/yyyy")))>1

    It would be appreciated if someone could amend my code
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Net Working Hours Between Two Dates/Times, Excluding Holidays
    By clari55a in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2023, 02:59 AM
  2. Count hours between two dates/times excluding weekends with condition
    By bhenlee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-10-2020, 07:42 PM
  3. [SOLVED] Business Hours between 2 dates/times excluding weekends and holidays
    By Skycap in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2019, 10:48 AM
  4. [SOLVED] How to highlight dates and times that overlap
    By MrChrisP in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-30-2017, 07:53 AM
  5. [SOLVED] Calculating handling times between two dates, in hours, excluding holidays/weekends
    By Tunesmith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2015, 01:44 PM
  6. Calculate Working Days (excluding weekends & holidays) between two dates/times
    By bool in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-19-2013, 05:45 AM
  7. [SOLVED] Calulating Time Between Two Dates/Times but Excluding Weekends and Holidays
    By randers1984 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2013, 10:24 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1