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

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