Thread: Automatic deletions
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Automatic deletions
Oops ... Line
Format B1 as date. Copy B1 to E1

should have read as
Copy B1 to E1. Format B1 as date.

(otherwise cols C to E will be in date format as well <g)

btw, the desired results -- ie the source list in X, less the expired
items --- are returned in Y's cols B to E
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply With QuoteReply With Quote