Automatic Date Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an update query that uses multiple parameters 2
Excel Formula to update itself automatically. 10
Automatically Record Date in a cell 1
what function to use? 2
Excel Highlight date ranges 1
Windows 10 How can I fix my corrupt registries? 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to add 30 days to date in another column, including Sat/Sun? 2

Back
Top