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.
|