J
JY
I have two columns (Start date) (End Date). I am trying to create a formula
that counts by Year then Places the by month
Start Date End Date
10/23/06 11/04/06
10/23/06 11/04/06
10/23/06 11/04/06
05/07/06 11/07/06
04/30/06 11/15/06
04/30/06 11/20/06
05/28/06 11/29/06
04/30/06 11/30/06
06/18/06 12/14/06
03/20/06 12/15/06
04/30/06 12/15/06
07/02/06 12/28/06
07/16/06 02/08/07
09/10/06 03/09/07
04/30/06 04/30/07
04/30/06 04/30/07
05/07/06 05/07/07
What I want the result to look like:
(i.e. The calulation result of the first row Would Be 1 For Oct and 1 For
Nov.
After Caluculating the secon row the result would be 2 for Oct and 2 Nov.
CY-06 CY-07 Deployed by month
6 16 JANUARY
5 15 FEBURARY
4 14 MARCH
9 13 APRIL
12 11 MAY
13 6 JUNE
13 3 JULY
13 3 AUGUST
15 2 SEPTEMBER
17 1 OCTOBER
21 NOVEMBER
17 DECEMBER
Thanks in advance for the assist.
that counts by Year then Places the by month
Start Date End Date
10/23/06 11/04/06
10/23/06 11/04/06
10/23/06 11/04/06
05/07/06 11/07/06
04/30/06 11/15/06
04/30/06 11/20/06
05/28/06 11/29/06
04/30/06 11/30/06
06/18/06 12/14/06
03/20/06 12/15/06
04/30/06 12/15/06
07/02/06 12/28/06
07/16/06 02/08/07
09/10/06 03/09/07
04/30/06 04/30/07
04/30/06 04/30/07
05/07/06 05/07/07
What I want the result to look like:
(i.e. The calulation result of the first row Would Be 1 For Oct and 1 For
Nov.
After Caluculating the secon row the result would be 2 for Oct and 2 Nov.
CY-06 CY-07 Deployed by month
6 16 JANUARY
5 15 FEBURARY
4 14 MARCH
9 13 APRIL
12 11 MAY
13 6 JUNE
13 3 JULY
13 3 AUGUST
15 2 SEPTEMBER
17 1 OCTOBER
21 NOVEMBER
17 DECEMBER
Thanks in advance for the assist.