| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calcualtion days in month from 2 dates
I have a start date and an end date, what I would like to do is to use these
2 dates to calculate the number of days per month. So for example Start Date: 23/03/06 End Date: 19/05/06 What I want to do is to work out how many days this is in March, April, May respectively. So I will end up with a column total for march of 8days, april 30days, may19days. any help would be gratefully accepted |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| 4 and 5 week months | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Threaded Mode
