Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating an Activities During Periods Of Natural Months and/or Dates
Hi,
A while back I posted regarding a challenge that I had, and I got great information. Here is another: 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 | |||
Calculating number of periods when payment amount changes | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Activities? Schimivities! | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |