Format the result cell as General or Numeric rather than as a date.

On Sat, 4 Jun 2005 11:35:07 -0400, "Walterius" wrote:

Many thanks, Duke. The first part works just fine: I get July 3, 2005 as
next month's date.

But when I subtract the two dates, I get January 30, 1900, instead of 30.
Viz:

C2=6/3/2005
B15=EDATE(C2,1)=7/3/2005 [correct]

But =B15-C2 = 1/30/1900

??? What am I doing wrong?

"Duke Carey" wrote in message
...
Instead of EOMONTH(), try EDATE()

=EDATE(earlier date,1)

will give you the same DAY next month. However, if you use it on a Jan 31
start date, it'll give you the lat day of February.

Then just subtract the two dates to get the # of days between them


"Walterius" wrote:

Excel 2002. I have a simple spreadsheet that logs my expenses by month.

I haven't been able to teach Excel how to calculate the same day next
month.
E.g., the 3rd of June is 06/03/05, so the 3rd of the next month should
be
07/03/05.

I also need the number of days in that period, e.g. from 6/03/05 to
7/03/05
= 30 days (because there are 30 days in June). I don't know how to
calculate
that either.

Attempts to use the EOMONTH function fail, and I can't find anything
else
that looks suitable. I have been using Excel for years and I am still an
Excel klutz. :-(

Many thanks for your help.

Walterius