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 choos
data, validation, then allow dates and choose the dates to allow

Regards

Da

--
Da
-----------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...fo&userid=2710
View this thread: http://www.excelforum.com/showthread.php?threadid=57252

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