software

This seems quite mundane after reading some of the things the rest of you are
working on, but!

I am building a payment booklet. I will be putting 4 payment coupons on each
page, to total 180. I put the start date in a cell (and the payment # in
another). I copy and pasted to the next section of the sheet adding an
=(above cell) 1 on the payment number and that works.
I can not find anything that works with the month. I want the payment due
the first of each month but with the varied # of days in the months I get
varied results if I use 30 or 31. Any help?

Thanks

=MONTH(A13) 1amp;quot;/quot;amp;DAY(A13)amp;quot;/quot;amp;YEAR(A13)

Vaya con Dios,
Chuck, CABGx3
quot;Tbonequot; wrote:

gt; This seems quite mundane after reading some of the things the rest of you are
gt; working on, but!
gt;
gt; I am building a payment booklet. I will be putting 4 payment coupons on each
gt; page, to total 180. I put the start date in a cell (and the payment # in
gt; another). I copy and pasted to the next section of the sheet adding an
gt; =(above cell) 1 on the payment number and that works.
gt; I can not find anything that works with the month. I want the payment due
gt; the first of each month but with the varied # of days in the months I get
gt; varied results if I use 30 or 31. Any help?
gt;
gt; Thanks

Alternatively, you can try this:

=DATE(YEAR(A13),MONTH(A13) 1,DAY(A13))

Both work...

quot;CLRquot; wrote:

gt; =MONTH(A13) 1amp;quot;/quot;amp;DAY(A13)amp;quot;/quot;amp;YEAR(A13)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Tbonequot; wrote:
gt;
gt; gt; This seems quite mundane after reading some of the things the rest of you are
gt; gt; working on, but!
gt; gt;
gt; gt; I am building a payment booklet. I will be putting 4 payment coupons on each
gt; gt; page, to total 180. I put the start date in a cell (and the payment # in
gt; gt; another). I copy and pasted to the next section of the sheet adding an
gt; gt; =(above cell) 1 on the payment number and that works.
gt; gt; I can not find anything that works with the month. I want the payment due
gt; gt; the first of each month but with the varied # of days in the months I get
gt; gt; varied results if I use 30 or 31. Any help?
gt; gt;
gt; gt; Thanks