HI there I need help, I need some function that can "decided that the end of 2008, at the very least, all pre 2003 PCs must be replaced with current models."
HI there I need help, I need some function that can "decided that the end of 2008, at the very least, all pre 2003 PCs must be replaced with current models."
It isn't urgent to me, but you can look in http://www.cpearson.com/excel/topic.htm for much information on Dates and the handling thereof.Originally Posted by r3born
hth
---
In my last post (to another question) I wondered about my limited ability in the area of Reading & Comprehension, and this post further confirms the need for concern.Originally Posted by r3born
Your company management should make such a decision, possibly as "by the end of 2008 at the very latest".
However, if you have an Excel worksheet that lists all of your pc's and such list contains a date being equal to, similar to, or a dirivitive of the date on which the pc was purchased, aquired, or otherwise obtained, then perhaps a small formula could highlight which listed pc's would need to be considered.
Assuming that said date is in column A starting from row 1, and in column B is an indicator as to whether the pc has already been disposed of, then the formula, placed in a vacant cell in row 1 (not being cell A1 nor B1) of:
=IF(B1="Replaced","Already done",IF(AND(YEAR(A1)<2003,YEAR(NOW())>2007),"Urgent Consideration",IF(YEAR(A1)<2003,"Consideration","Valid")))
should go close to what I thought you asked for.
hth
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks