Hi,

I work for an insurance company using Excel 2002. I need somehow to input
the following via command button into the cells based on a cell call
inception or expiration date.
For example I have the following fields in two separate cells:

Inception Date Expiration Date
9/30/2005 9/30/2006

What I want is to pick the inception/expiration (don't know what is best to
use) date using a command button to get the following: to a row of cells.

1st Qtr - 12/31/2005
This will be the 1st quarter after 9/30/2005 the second quarter to a new
cell will be:
2nd Qtr - 3/31/2006
The third quarter will be
3rd Qtr - 6/30/2006
The fourth quarter will be
4th Qtr - 9/30/2006

It should all be on a quarterly calendar basis. This is for payroll
purposes. If I get an expiration date that is for example 10/31/2005 I want
to show the first quarter to be: 12/31/2005, second quarter 3/31/2006 and
so on. Can this be done? Thank you in advance.