Formula Help
 

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.

Formula Help
 

use

=MONTH(A1)

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

"pls" wrote:

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.

Formula Help
 

Try =MONTH(A1)

Hope this helps,

Hutch

"pls" wrote:

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.

Formula Help
 

i should have known it would have been that easy... thanks guys.

"Tom Hutchins" wrote:

Try =MONTH(A1)

Hope this helps,

Hutch

"pls" wrote:

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.