=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

title updated 8/11

You need to try a bit harder than that, sorry. You have explained in your opening post what you want to do - use this for your title, in summary form.

Please Login or Register  to view this content.

That was just a guess since there is no sample file to test with.

---

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

What people usually do to help those trying to help them is provide a desensitised version of their workbook. Just anonymise the data and there shouldn't be a problem.