Formula Help

P

pls

I'm trying to pull only the month from a date in cell A-1 and display it in
the adjacent cell. when using the formula =LEFT(A1,FIND("/",A1)-1)
i am getting a # value! error. if i go through the solver macro, the
formula is solving the date entered in cell A-1 as a number, rather than a
date. A-1 is formatted to display a date.
 
T

Toppers

use

=MONTH(A1)

A1 is held in date format (and internally as a number) so you cannot use
your formula.
 
Top