View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default EOMONTH() question

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