do ...
you take Mon Nov 11 13:03:23 2002
to get the month, you look for: trim(right(left(CELL,7),3))
to get the year, you look for: trim(right(CELL,4))
to get the Day, you look for: trim(right(left(CELL,10),2))
You need to get the month number ... I just made a table on one sheet with two columns ... jan ...dec, and 1-12 ... then do a vlookup to get the month number
to get the monthnumber: vlookup(monthtext,rangeof table,2,false)
then to get a date: date(year, monthnumber, day)
for my count, I used =countif(E:E,">today()-30") |
