software

I have several payments in need to pay in one month. For example, my
telephone bill is due on the 8th and my utility bill is due on the 13th of
every month.

I would like to display the payment date so that if today is the 9th of
March, then my next payment for telephone will be April8th while my utiltiy
will be the 13th of March.

In advance, thank for your help.

Here's how to do it for the phone bill

=DATE(YEAR(TODAY()),MONTH(TODAY()) (DAY(TODAY())gt;8 ),8)

do the same for the utility bill but change every reference of 8 to 13
format cell as date

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Vannaquot; gt; wrote in message
...
gt;I have several payments in need to pay in one month. For example, my
gt; telephone bill is due on the 8th and my utility bill is due on the 13th of
gt; every month.
gt;
gt; I would like to display the payment date so that if today is the 9th of
gt; March, then my next payment for telephone will be April8th while my
gt; utiltiy
gt; will be the 13th of March.
gt;
gt; In advance, thank for your help.