Thread: Maximum date in a Month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Maximum date in a Month
Assuming your input date is in cell A1, try this formula:


=DATE(YEAR(A1),MONTH(A1)+1,0)

tom
Reply With QuoteReply With Quote