Hi everyone,

My 1st post here

I am trying to extract a month into one column and a year into the next column. First, the month extraction attempt:

Book Date Created Date Formula used Result received Result should be
10/13/2016 9/27/2015 =TEXT(G2, "mm") 10/13/2016 10


It fails to give me the expected result ("10") and I am not sure where things are going wrong. Both source and result cell are formatted as General.

If I try to use =MONTH(G2) as another extraction option, then the result becomes #VALUE!. Stepping through the calculation steps shows:
"The cell currently being evaluated contains a constant"


Many thanks in advance for any assistance provided.


Cheers,
Wojtek