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

lock moth for a date column
 

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

lock moth for a date column
 

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

lock moth for a date column
 

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

lock moth for a date column
 

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

lock moth for a date column
 

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

lock moth for a date column
 

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

lock moth for a date column
 

Good solutions, thx for helping put :o)

Regards,
Ladyhawke