Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
Update a formula based on date worksheet was saved | Excel Worksheet Functions | |||
Enable Automatic Update for Web Query | Excel Worksheet Functions | |||
Enable Automatic Update for Web Query | Excel Worksheet Functions | |||
Automatic Chart Update? | Charts and Charting in Excel |