| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate days in a month
I have data in columns as follows:
Start date | End date | April | May | June What I am trying to get is how many days are in each of the column months. For instance : Start date - Jan-4-08 End date: April-2-2008 then a formula that will post 2 in column April , 0 in May and 0 in June 15-April-08 to 9th June 2008 will put 15 , 31 , 9 in respective columns 02-June-08 to 09-July-08 will put 0,0,28 thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate days in each month | Excel Worksheet Functions | |||
| How to calculate days in the month | Excel Discussion (Misc queries) | |||
| Calculate Number of Days in a Month | Excel Worksheet Functions | |||
| 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
