Still needing help with the date

B

Brandy

Thought I would repost to make it easy.

I'm looking for help with determining which data only
occurred in the month of July, but my date format must
remain xx/xx/xx because my data form is printed for my
board of directors.

It has been suggested that I format the date xx/xx, but
that will not work for my purpose. Any other ideas?
 
R

Ron de Bruin

Hi Brandy

You can use a helper column with this formula
=MONTH(A1)

And then use Data>auto filter on that column
 
L

Lady Layla

Copy the data you need to a different spreadsheet. That way you can move it
change it etc anyway you want and the board will not be bothered.

If you date is in date format, then you will be able to pick the dates as
everyone has suggested. If it is in text format, then you may have problems




: Thought I would repost to make it easy.
:
: I'm looking for help with determining which data only
: occurred in the month of July, but my date format must
: remain xx/xx/xx because my data form is printed for my
: board of directors.
:
: It has been suggested that I format the date xx/xx, but
: that will not work for my purpose. Any other ideas?
 
P

Peo Sjoblom

You were suggested to format the cells as mm/dd because you asked for it

Use the autofilter as Ron suggested or use a help sheet directly linked with
the custom format

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top