Number of days in a specific month between various start and e
Thanks Fred!!!!! It works great!!!
"Fred Smith" wrote:
Assuming the '55 days' in April is a typo, you probably want something like
this:
=MAX(0,MIN(B1,DATE(2009,5,1))-MAX(A1,DATE(2009,4,1)))
It will return zero if the date range doesn't span any days in April, as in
your second example.
Regards,
Fred.
"ibvalentine" wrote in message
...
I am looking for a formula that will return the number of days of a
particular month between start and end dates.
For example, if the start and end dates are as follows:
2/23/09 5/6/09
3/12/09 3/28/09
3/2/09 4/16/09
How many days is there in April for each of the three start and end dates?
For the first record, there should be 30 days, for the second, 16 days,
and
for the third, 55 days, but what is the formula?
|