Extract a specific digit from date?

[mabubakerali]

Is there any way i can extract a digit from specific place from a date e.g there is date written in cell A1, 31-Dec-2024, Now i want to extract "1" which is "1" from december because december is 12th month and i want to return "1" in cell A3.

 

[etaf]

not following exactly
can you give more examples

also
What version of excel are you using - would be worth updating your profile to show version as solutions will be dependant on what version you have and therefore what functions available

 

[mabubakerali]

not following exactly
can you give more examples

also
What version of excel are you using - would be worth updating your profile to show version as solutions will be dependant on what version you have and therefore what functions available

latest version ofcourse. Just Reply according to the latest version of excel 365

 

[RoryA]

Why 1 from December? What would you want from July - 7 or 0, or something else?

 

[mabubakerali]

Why 1 from December? What would you want from July - 7 or 0, or something else?

YEA it will be "0" if its july.

 

[etaf]

still not following
can you give the numbers needed for each month
as i said in first post

not following exactly
can you give more examples

 

[RoryA]

You can use
=LEFT(TEXT(A1,"mm"),1)

 

[Phuoc]

Like this?

=--(MONTH(A1)>9)

 

[mabubakerali]

You can use
=LEFT(TEXT(A1,"mm"),1)

Thanks alot man, it worked for me.