$$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

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(1RIGHT(A1,3))-MONTH(1LEFT(A1,3)) to get the desired result. Cheers, Andy On Thu, Jul 15, 2010 at 10:43 PM, Nadine S n8dine4ma...@yahoo.com wrote: If a cell says Apr - Jun what formula is there to count how many months