I am trying to set up a VBA routine that counts the number of days
HERE vs AWAY. The sample events start (e.g., a_s) and end (e.g.,
a_e) at random dates within the period: July 1 thru Aug 6
All event periods are "AWAY" the rest are considered "HERE"
Sample Events:
a_s: 5-Jul
a_e: 21-Jul
c_s: 5-Jul
c_e: 21-Jul
e_s: 6-Jul
e_e: 24-Jul
g_s: 4-Jul
g_e: 20-Jul
i_s: 6-Jul
i_e: 20-Jul
k_s: 26-Jul
k_e: 4-Aug
Graphing these dates out (the hard way) for the period July 1 thru Aug
6 I come up with:
AWAY: 31 DAYS
HERE: 6 DAYS
Is there a VBA routine or an array that can handle this routine? Any
help greatly appreciated!!!
RBollinger
