View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mastermind mastermind is offline
external usenet poster
 
Posts: 36
Default Calculating the end of the month

I have a sheet that needs to be able to alternate between the 15th and
last day of each month. The user will enter a start date, and I need
the code to start at this point and jump to the next date. Example:


Start date: 01/15/06
run code
date: 01/31/06
run code
date: 02/15/06
run code
date: 02/28/06

and so on. Can anyone help me with this problem? Thank you.