Count months away betwwen a strat and end date by month


G

Guest

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.
 
Ad

Advertisements

B

Bernard Liengme

Not sure I understand the question.
If you want to know how many months there are between two dates then use the
DATEDIFF function - look a Chips site www.cpearson.com for details as it is
not documented in Help
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top