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