Sorry Dave missed this reply. using your formula adds 1 day to the date

Mike

"David Biddulph" wrote:

The cell may well be formatted as a date but contain text. What do you see
if you enter, in another cell, =A1+1 ?
--
David Biddulph

"Mike" wrote in message
...
Thanks Dave but the target cell is formatted as a date.

"David Biddulph" wrote:

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