Re: $$Excel-Macros$$ Count months

2010-07-15 Thread Aindril De
Dear Nadine, Assuming cell A1 has Apr-Jun. In Cell B1 you can type =MONTH(1&RIGHT(A1,3))-MONTH(1&LEFT(A1,3)) to get the desired result. Cheers, Andy On Thu, Jul 15, 2010 at 10:43 PM, Nadine S wrote: > If a cell says Apr - Jun what formula is there to count how many months > that is? The month

$$Excel-Macros$$ Count months

2010-07-15 Thread Nadine S
If a cell says Apr - Jun what formula is there to count how many months that is?  The month range is in one cell and the formula would be in another.  Thanks. Nadine -- -- Some important links for excel use