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?

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?

I am trying to build a macro with the filter so I will have to use a fomula
without putting in a specific date, I am sorry I was not more clear on this,
Thank you Farhad for replying. Does anybody have any ideas?

"Farhad" wrote:

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?

Ok. What's the formula?

If, for example, you want the last three days (ie, today, yesterday and the day
before yesterday), use something like:

Startdate = date - 3
selection.autofilter field:=1, criteria1:="<" & startdate

--
Regards,
Fred


"mulehead" wrote in message
...
I am trying to build a macro with the filter so I will have to use a fomula
without putting in a specific date, I am sorry I was not more clear on this,
Thank you Farhad for replying. Does anybody have any ideas?

"Farhad" wrote:

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?