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