Automatic Date Update

[Jmoore]

Im trying to get my date to automatically update to when the next payment
would be due...im using excel 2003 any help would be great!

[Gord Dibben]

Excel has no way of knowing when the next payment could be due.

You have to give Excel a hint.

When was last payment?

When is next payment due?

......1st of next month?

Assuming you have a date in A1 of November 1, 2005

In B1 enter =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

Will return December 1, 2005


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 10:11:07 -0800, Jmoore <[email protected]>
wrote:

>Im trying to get my date to automatically update to when the next payment
>would be due...im using excel 2003 any help would be great!