View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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?