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.
Good, with replace, i ge rid of useless info, like the last message rolls.
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:
So, i had to tell Excel that online=today
Anyway, i worked this out too . . .
Bookmarks