ExcelBanter - Automatic Date Update

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Automatic Date Update (https://www.excelbanter.com/excel-worksheet-functions/56008-automatic-date-update.html)

Automatic Date Update

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!

Automatic Date Update

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
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!