lock moth for a date column

How can this be done?
I would like to force dates entered to be of a certain month... E.g. in
one sheet only dates from february can be entered.

Regard,
Ladyhawke

On the cells you wish this to apply to (so select them) then choose data, validation, then allow dates and choose the dates to allow

Regards

Dav

That works ok except it restricts year values too can I some how (VBA
if needed) replace the dates entered withe the entered date except with
the month corrected to the value I specify?

regards,
Ladyhawke

ladyhawke,

You can still use the Data => Validation, but choose List, and type
"Month" in the option box. This will then be the only allowed value.

This will only work if each entry needs to be the same, if you are
trying to allow varieties within a month, then you may need to
investigate VBA solutions. It is unclear the type of value you want in
your column. Is it dd/mm/yy, or dd/mm or just mmmm?

Steve

I re-read your post:

If you list your dates using the DATA -> VALIDATION -> LIST you can
add dates

"01 Feb","02 Feb","03 Feb", etc

Steve

This sounds like a useful solution, and yes I would like the date (not
month) to change, even the year or just exclude year from the date...

Regards,
Ladyhawke

SIR Knight skrev:

> I re-read your post:
>
> If you list your dates using the DATA -> VALIDATION -> LIST you can
> add dates
>
> "01 Feb","02 Feb","03 Feb", etc
>
> Steve

Under data validation, you could also look at the custom formula approach

=Month(A1)=2

for example. You would perhaps need to further restict as errant numbers
could pass that test.

--
Regards,
Tom Ogilvy


"ladyhawke" wrote:

> This sounds like a useful solution, and yes I would like the date (not
> month) to change, even the year or just exclude year from the date...
>
> Regards,
> Ladyhawke
>
> SIR Knight skrev:
>
> > I re-read your post:
> >
> > If you list your dates using the DATA -> VALIDATION -> LIST you can
> > add dates
> >
> > "01 Feb","02 Feb","03 Feb", etc
> >
> > Steve
>
>

Good solutions, thx for helping put :o)

Regards,
Ladyhawke