I have been able to solve this one yet, so let me try to explain some
more.

Cell CN2 will contain the date of the last Monday of the month –
formatted as d. Cell CP2 will either contain the EOM date (if EOM
falls on Tuesday, Wednesday, Thursday or Friday) or blank (if EOM also
falls on the last Monday). For example:

For May 2006:
Cell CN2 will contain 29
Cell CP2 will contain 31
So with the data validation setting, only 29, 30 or 31 should be
allowed in cell CK5

For June 2006:
Cell CN2 will contain 26
Cell CP2 will contain 30
So with the data validation setting, only 26, 27, 28, 29 or 30 should
be allowed in cell CK5

For July 2006:
Cell CN2 will contain 31
Cell CP2 will be blank
So with the data validation setting, only 31 should be allowed in cell
CK5

Hope this helps

Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=566845