Excel 2007 : Date cells not being identified as dates !

Greetings,

after spending many hours and days trying to fix this problem, i could not solve it and i am here asking for your help

I am looking for a way to control the inactivity of people in my irc channel/server.

So, what i do is:
1- in irc i do a "/msg nickserv info XXX" the output information would look like this.

Jul 10 00:02:17 -NickServ- XXX is ZZTTRR
Jul 10 00:02:17 -NickServ-   Time registered: May 28 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ-   Last seen time: Jun 28 23:13:44 2008 UTC
Jul 10 00:02:17 -NickServ- Last quit message: Quit:
Jul 10 00:02:17 -NickServ- ZZZ is UUUTTTDDD
Jul 10 00:02:17 -NickServ-   Time registered: May 28 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ-   Last seen time: Jun 28 23:13:44 2008 UTC
Jul 10 00:02:17 -NickServ- Last quit message: Quit:

Good, with replace, i ge rid of useless info, like the last message rolls.

Jul 10 00:02:17 -NickServ- XXX is ZZTTRR
Jul 10 00:02:17 -NickServ-   Time registered: May 28 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ-   Last seen time: Jun 28 23:13:44 2008 UTC
Jul 10 00:02:17 -NickServ- ZZZ is UUUTTTDDD
Jul 10 00:02:17 -NickServ-   Time registered: May 29 21:40:13 2008 UTC
Jul 10 00:02:17 -NickServ-   Last seen time: Jun 20 23:13:44 2008 UTC

So, now i created a formula to:
*1* print in a specific column (Name), the nick (XXX and ZZZ). (I am not interested in the is ZZTTRR and is UUUTTTDDD)
*2* print the date registered in another column (Registered)
*3* TODAY() - "the printed registered date" in another column (Age)
*4* print the last seen date to another column (Last seen)
*5* TODAY() - "the printed last seen date" in another column (Inactivity)


Everything seem to be working really good.

The problem is that in the dates printed on *2* and *4* are not being seen as dates, so the TODAY()- "the cells" (on *3* and *5*), wont work, because "TODAY()- Apr 12,2008" is not possible ?

what am i missing here . . . ?


Please, i believe the BIG formula is correct . . .

edit,

between, i forgot to mention that the output text is not always in the same "format".

Sometimes, this pops up:

Jul 14 17:58:54 -NickServ-	JJJJJ is New Now Know How
Jul 14 17:58:54 -NickServ-	JJJJJ is currently online.
Jul 14 17:58:55 -NickServ-	  Time registered: Apr 19 17:51:30 2008 UTC

So, i had to tell Excel that online=today

Anyway, i worked this out too . . .