| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CALCULATE DAYS PER MONTH BETWEEN 2 DATES
I am trying to calculate days between a start date and end date for each
month. If start date and end date are same day, formula should return 1. Columns A-AD are in use for other data. Below is an example of what I want to see. Help, please? Example: A B ... N €¦ R S T €¦ AB AC 1 Start End JAN FEB MAR NOV DEC 2 1/2/09 1/2/09 1 3 1/16/09 3/27/09 16 28 27 4 2/3/09 3/11/09 26 11 5 11/13/09 12/13/09 18 13 6 1/12/09 12/1/09 20 28 31 30 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate days in a month | Excel Worksheet Functions | |||
| Calculate days in each month | Excel Worksheet Functions | |||
| How to calculate days in the month | Excel Discussion (Misc queries) | |||
| How to calculate a date: first day of the month after 60 days | Excel Discussion (Misc queries) | |||
| Calculate Days in a Month | Excel Discussion (Misc queries) | |||
Threaded Mode
