Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Days Within Months
Hi,
I've posted this twice, and there has been no reply. Either no one knows the answer, or no one understnads my question? I am trying to calculate the occurrence of an activity during a given month within a period. For example: Let's say that Jan came to visit from Feb 15 to April 25. How can I get Excel to calculate how many days she stayed during the months of Feb, March, and April? I would want it to break it down like this: Feb 13 March 31 April 25 Also, an add-on for calculating random dates.... where I can input March 31 and April 10 and get the results: March 1 April 10 I know that it can be done, since I ended up with a horrific formula with if's and then's for each month, that I had to repeat for each month (column). However, it is very hard to work with. Is there an easier way? Thanks for your help! Rayco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting days to months | Excel Worksheet Functions | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
days and months swapping when copying using VB | Excel Discussion (Misc queries) | |||
difference between two dates in years, months and days. | Excel Worksheet Functions |