Hi Max,

Thank you for your response. The formula works, however it's returning the
incorrect date. If the date in column A is say 12/07/09, it returns 31/07/09
when it needs to return 31/08/09. Sorry if I hadn't made that clear.
--
Thanks for the help


"Max" wrote:

You can also use: DATE(YEAR(A10),MONTH(A10)+1,0)
to replace: EOMONTH(A10,0)
in NBVC's expression

btw, do hit the YES's (like the one below) in all responses which help
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"JS" wrote:
.. however 5 doesn't work - it's returning the #NAME? error