Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date calculations
I've created a spreadsheet to deal with various lines of credit i'm
dealing with (mortgage, credit cards etc). The sheet lays out the entire payment schedule until the credit line is paid off...there's just one thing left to do. I want to be able to enter the starting date (date of my next payment) on line one, then every line after that i want to increment the date by 1 month. According to Excel help files I just use [=EDATE(A1,1)] where A1 is the start_date and 1 is supposed to increment the date by 1 month. It's not working. I'm getting #NAME? as a result. I'm very new to excel calculations so I'm not sure what to do next??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date calculations
=EDATE(A1,1) works fine for me, but obviously the cells must be formatted as
date, otherwise it will display the numeric date value. Make sure you refer to the correct cell containing the start date, though "Brian" wrote: I've created a spreadsheet to deal with various lines of credit i'm dealing with (mortgage, credit cards etc). The sheet lays out the entire payment schedule until the credit line is paid off...there's just one thing left to do. I want to be able to enter the starting date (date of my next payment) on line one, then every line after that i want to increment the date by 1 month. According to Excel help files I just use [=EDATE(A1,1)] where A1 is the start_date and 1 is supposed to increment the date by 1 month. It's not working. I'm getting #NAME? as a result. I'm very new to excel calculations so I'm not sure what to do next??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date calculations
On 8 Mar 2006 09:36:35 -0800, "Brian" wrote:
I've created a spreadsheet to deal with various lines of credit i'm dealing with (mortgage, credit cards etc). The sheet lays out the entire payment schedule until the credit line is paid off...there's just one thing left to do. I want to be able to enter the starting date (date of my next payment) on line one, then every line after that i want to increment the date by 1 month. According to Excel help files I just use [=EDATE(A1,1)] where A1 is the start_date and 1 is supposed to increment the date by 1 month. It's not working. I'm getting #NAME? as a result. I'm very new to excel calculations so I'm not sure what to do next??? Did you look at HELP for the EDATE function? Starting about the fourth line down: If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. How? On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
Date difference | Excel Worksheet Functions | |||
Setting up "Year to Date" Calculations in a Pivot Table | Excel Worksheet Functions | |||
date and time | New Users to Excel | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |