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 |
#2
|
|||
|
|||
Hi, If someone visits between Feb and Apr, it would be less confusing if she were not called Jan(uary) Put the start date in A1, the end date in A2 and format cell A3 to be a number (not a date) then =A2-A1 should gives the number of days, or =A2-A1+1 give the number of days inclusive. Rayco Wrote: 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 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=474654 |
Reply |
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) |