My guess is that what you think is a date is actually text.
--
David Biddulph

"Mike" wrote in message
...
i have dates in a column and in the next column im using the formula
=eomonth(a1,1) and instead of getting the last day of the next month I'm
getting a "#value!" error despite being fairly sure the formula is
correct.
Any suggestions?

Mike