Calculating an Activities During Periods Of Natural Months and/or Dates

[Rayco]

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]

Hi,

If someone visits between Feb and Apr, it would be less confusing i
she were not called Jan(uary)

Put the start date in A1, the end date in A2 and format cell A3 to be
number (not a date)
then =A2-A1 should gives the number of days, or
=A2-A1+1 give the number of days inclusive.