Thread: Filter Date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default Filter Date

Hi,

You can do it by auto filter and the filter by choosing costom and:

for today put equal to 09/21/2007 and
for last 3 days put grater than 09/19/2007

Thanks,
--
Farhad Hodjat


"mulehead" wrote:

How do you filter dates to show the last date or the last three dates in a
spreadsheet relative to the current dates on a spreadsheet, meaning without
actually entering a specific date?