Value err

[Tharun Kumar G]

Please help me understand why I am getting value error in the attached file and how I can get rid of the same to extract the right month.

 

[Debraj]

Provided data look like date are actually TEXT.

s.. in B2
=MONTH(DATEVALUE(A2))

or

=MONTH(A2*1)

and in F2 use formula as..
=DATEVALUE(LEFT(E2,10))

 

[Tharun Kumar G]

Tried all the three it is not working for all cells.

 

[NARAYANK991]

Hi Tharun ,

Try this :

=(MID(E2,4,3)&LEFT(E2,3)&MID(E2,7,4))+RIGHT(E2,LEN(E2)-10)

The above will convert the data in column E to proper date + time combinations ; now you can use the MONTH( ... ) function or the TEXT( ... ) function to retrieve the month in your desired format.

Narayan

 

[Tharun Kumar G]

Dear Narayan_ it worked. Thank you so much!.. Deb thank you too