Can Excel automatically highlight dates in the next week?
Hi
we're a bit light on detail here, but maybe what you want is with Date
borrowed in column A, enter in B1
=IF(A1<"",TODAY()-A1,"")
Format B1 as follows
FormatCellsNumberGeneral
Copy down column B as far as required
Column B will show how many days have elapsed since the item was borrowed.
--
Regards
Roger Govier
"georgiakate1039" wrote in
message ...
I'm using excel 2003. I want to make it easier to see when borrowed items
need to be returned soon. Is this possible?
|