Date Custom Filter

If you want something a bit more complex, such as a range of dates, you need to do a bit more work. The following screen shows how you can manually filter the data in a table to show a particular month. Click the drop-down button beside Date and choose Date Filters. Then select either Custom Filter or Between. You can then fill in the dialog box as shown in Figure 6-6.

The format you use when you type in dates in the Custom AutoFilter dialog box depends on your regional settings. You can use a dd/mm/yy format if you work with UK settings, or a mm/dd/yy format if you work with U.S. settings. Some formats that are more international, such yyyy-m-d, are also recognized. You can use the calendar controls in the AutoFilter dialog box to insert your dates in your regional date format.

©jpatatrse.ilsm

- □ t

ft 1 a

C

D E

F

a 1 a 1 j

K

L

M'a

4 j

r

£

iT^^Bi .¡"[tii'iiiiiiij ■

- iisruiiFii -mnrnimT

lEl^ L

JiPTI'lÜ

'■V.'Jill'J » 1

222

Jan 91 2097 Smith

VIC

Apples

520

12 5.

6500

223

Jan 05. 2007 Pradesh

SA

Pears

856

18

15408

W4

Jan 06 2007 Pradesh

TAS

Apples

247

12 6

3037 5

227

Jan 06. 2007 Pradesh Jan 06 2097 Robarts Jan 06 2007 Roberts

SA VIC TAS

285

20 15

10820

Pears

Custom in(1 rltel

=

228

Jan 07 2007 Pradesh

WA

Pears

191

18

Show rows where:

22S

Jan 09. 2007 Kee

NSW

Apples

339

12.5

Date

■/Ml

Jan 13 . 2007 Kee

NI

Apples

«

12 5

is after orequai to w 12E07-1-1

0tnd Off

I«. \M

231

Jan 13. 2007 Pradesh

NT

Mangoes

943

20

■JH-J

Jan 13, 2007 Pradestl

NSW

905

16

233

Jan 13. 2007 Roberts

SA

Apples

843

125

is before or equal to v 12D07-1-31

I v

M

234

Jan 13. 2007 Robarts

SA

Oranges

84

15

236

Jan 14 2007 Pradesh

TAS

Oranges

314

is

Use ? tea represent any angle diarat±er Use "to represent any series Bf<±arartsrs

Jan 15, 2007 Kee

IAS

Mangoes

m

20

Jan 19. 2007 Roberts

NT

Mangoes

414

20

OK

I Cancel |

233

Jan 2 0 2 007 Kee

WA

Oranges

589

15

239

Jan 21. 2007 Kee

VIC

Oranges

224

15

336(1

740

Jan 22 2097 Robarts

SA

Oranges

864

15

129S0

'24.1

Jan 26. 2007 Pradesh

NT

Apples

43

KS

537.5

242

Jan 27 2007 Kee

QLD

Mangoes

62

20

1240

■243

Jan 27 2007 Pradesh

VIC

Mangoes

206

20

4120

244

Jan 23 2007 Roberts

TAS

Pears

139

18

2592

245

Jan 28. 2007 Smith

VIC

Oranges

20

15

300

246

Jan 2S, 2007 Roberts

NT

Apples

221

XLS

2762 5

247

Jan 29. 2007 Smith

ÜLD

Oranges

610

15

9150J

4341

m

► h Sales

I'll'] mi

0 0

Post a comment