Data Validation-Custom formula

[Guest]

I'm trying to set the validation to limit entries in cell K8 to the last day of the month e.g. 31/07/2004.
I'm using the formula =eomonth(k8,0)=k8 which calc correctly in the sheet.
* Entering with the leading = gives an error, but when I copy the formula in the Help example it allows the leading = sign?
* Then when entering 31/7/2004 or any other eomonth date, validation returns an error.

How do I fix this?

 

[Andy B]

Hi

One way using Custom:
=K8=DATE(YEAR(K8),MONTH(K8)+1,0)
This works on the fact that Excel believes that the 0th of a month is the
last day of the month before.

--
Andy.

I'm trying to set the validation to limit entries in cell K8 to the last

day of the month e.g. 31/07/2004.

I'm using the formula =eomonth(k8,0)=k8 which calc correctly in the sheet.
* Entering with the leading = gives an error, but when I copy the formula

in the Help example it allows the leading = sign?