Does that cell contain a date?

If yes, then how about:

dim myMonth as Long
mymonth = month(activesheet.range("A1").value



Papa Jonah wrote:

I want to use someting like the left command to identify the number to the
left of the first "/".
My intent is to identify the month entered in a cell (first digit or two to
the left of the first "/") so that I can then use if then statements to
automatically identify the quarter that the date falls in.

TIA
Papa

--

Dave Peterson