+ Reply to Thread
Results 1 to 8 of 8

COUNTIF with Date formula

Hybrid View

  1. 12-20-2006, 08:52 AM #1
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    In this case, you have a date format problem somewhere ...or in D3

    Do you mind uploading a zipped copy of your worksheet ...?

    Carim
    Reply With QuoteRegister To Reply
  2. 12-20-2006, 09:02 AM #2
    Jay__Oh
    Jay__Oh is offline
    Registered User
    Join Date
    12-20-2006
    Posts
    4
    Attached.

    I'm trying to list the number of occurances of D3 in the range & results in D6 & the same for E3&E6 etc....
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 12-20-2006, 09:33 AM #3
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    In cell A1, replace now() by today() ...

    as I told you the date formats can be tricky ... now() shows both today() and the exact time ... which prevents any matches ...


    HTH
    Carim
    Reply With QuoteRegister To Reply
  4. 12-20-2006, 09:44 AM #4
    Jay__Oh
    Jay__Oh is offline
    Registered User
    Join Date
    12-20-2006
    Posts
    4
    LEGEND!

    Thankls Carim
    Reply With QuoteRegister To Reply
  5. 12-20-2006, 09:45 AM #5
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad it fixed your problem

    Thanks for the feedback

    Carim
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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