Results 1 to 11 of 11

=count separate date & time and count dates inside or outside 30 days

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    Ahouse
    MS-Off Ver
    thatone
    Posts
    5

    =count separate date & time and count dates inside or outside 30 days

    hello,

    I don't really know what I'm doing, however, I've been tasked with collecting dates that have been active within the last 30 days.. There's a problem, the cell contains "Oct 4, 2016 02:46:50 EDT", as an example. I need to separate the time from the date and then count the dates that are active within the last 30 days relative to current/today's date.

    Here's what I've come up with so far... but the end result is not what I'm looking for.....

    =COUNTIF(Table3[First Discovered],"<"&TODAY() +30)&" "& LEFT(Table3[First Discovered], LEN(Table3[First Discovered]) -13)

    It displays = 0 Oct 4, 2016

    please make my life easier so I can continue please! :-)

    Beret
    Last edited by Beret; 08-11-2017 at 06:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  2. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  3. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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