View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gottahavit gottahavit is offline
external usenet poster
 
Posts: 13
Default Last day of the month

I am trying to write a macro that takes a certain date from a cell, adds 1
quarter to the month and return the last day of that month.
For example, if the date in the cell is 9/30/2005, I want it to return
12/31/2005.
Most things I tried gave me 12/30/2005.

Thanks.