Thread: converting "May" to 31, "June" to 30, etc.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
DaveO[_2_] DaveO[_2_] is offline
external usenet poster
  
Posts: 46
Default converting "May" to 31, "June" to 30, etc.
Hi, Dave-
Is AN3 a date cell? This formula finds the last day in a month
specified in a date cell:
=EOMONTH(AN3,0)

Can you work that in somehow?

Dave O

Reply With QuoteReply With Quote