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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


message
news:[email protected]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Payment Days and Date 3
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Calc Prorated Cost based Specific Days in a Gven Month & Year Range. 3
Formula to calculate exact months and days between two dates 3
Expanding Date formula 1
Excel Message box with days of month & date. 1
Calculating age at different points in time 1
VBA to run all variable combinations in a calculation model and store result 6

Back
Top