Nuttapper
03-26-2004, 12:24 PM
Hi Guys anyone assist me with this please.
Office Xp (excel)
I have a column (say A1 to A256) full of dates in this format 15/03/2004
what I want to be able to do is get excel to tell me which dates are older than 4 weeks, and return a comment in the cell, like "overdue"
I've read up on the "if" function, but wondered if it could be used as a single command for a cell range rather than each cell at a time.
I would also want the command to grow with the spread sheet, so when I got to cell say, A300 the command would still be working with the current cell (A300)and still with cell A1
The above is =IF(TODAY()-A2<28, "Okay","oVerdue") Big thanks to hood1971 from the cdrom forum (not sure if he's on here?)
Next problem :)
Column A contains variable details that all have different sell by dates, so
A1 may have a sell by date of 2 days (term is fruit)
A2 has a sell by date of 7 days (term is bread)
A3 has a sell by date of 28 days (term is frozen)
A4 may be 28 days again (term is frozen)
I need to be able to apply the formula, so that it can be applied to a single column "G" for the results "oVerdue" "Ok"
Im not sure how to do this as the results may be different for each row 2 days 7 days and 28 days.
what I want to say is:
If column A = bread >7days, or fruit >2days, or frozen>28 days, return "oVerdue" in column "G" If not return "oKay"
Thanks
Nuttapper
Office Xp (excel)
I have a column (say A1 to A256) full of dates in this format 15/03/2004
what I want to be able to do is get excel to tell me which dates are older than 4 weeks, and return a comment in the cell, like "overdue"
I've read up on the "if" function, but wondered if it could be used as a single command for a cell range rather than each cell at a time.
I would also want the command to grow with the spread sheet, so when I got to cell say, A300 the command would still be working with the current cell (A300)and still with cell A1
The above is =IF(TODAY()-A2<28, "Okay","oVerdue") Big thanks to hood1971 from the cdrom forum (not sure if he's on here?)
Next problem :)
Column A contains variable details that all have different sell by dates, so
A1 may have a sell by date of 2 days (term is fruit)
A2 has a sell by date of 7 days (term is bread)
A3 has a sell by date of 28 days (term is frozen)
A4 may be 28 days again (term is frozen)
I need to be able to apply the formula, so that it can be applied to a single column "G" for the results "oVerdue" "Ok"
Im not sure how to do this as the results may be different for each row 2 days 7 days and 28 days.
what I want to say is:
If column A = bread >7days, or fruit >2days, or frozen>28 days, return "oVerdue" in column "G" If not return "oKay"
Thanks
Nuttapper