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
Bookmarks