How do I calculate how many days in which months given two dates .
 

Given a From and To date, how do I calculate how many days there are and the
months they are in.
This calculation is used because different months are priced at different
rates per day.
I am using Excel97.

How do I calculate how many days in which months given two dates .
 

To get the number of days between two dates, simply subtract the
earlier date from the later date. To determine what month a date
falls in, use the MONTH function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nick Rogers" <Nick wrote in
message
...
Given a From and To date, how do I calculate how many days
there are and the
months they are in.
This calculation is used because different months are priced at
different
rates per day.
I am using Excel97.