| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
| Excel - Calculate age from DOB in years, months days | Excel Worksheet Functions | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| how do i calculate age in term of years, months, days | Excel Worksheet Functions | |||
Linear Mode
