Agreed.

OP: If you still want to play this tack, change B1 to:
=IF(AND(DAY(A1)<1,A1<DATE(YEAR(A1),MONTH(A1)+1,0 )),A1,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"daddylonglegs" wrote in message
...
But that would skew the results, dates which are the 2nd or 3rd of the
month
would be more likely to appear....and you could also generate dates
outside
the range.