EXTRACT DATE FROM DDD-DD-MM-YY

[thedeadzeds]

Hi Guys,

What is the best way to extract the start of the month in "DD/MM/YY" format from the below and store it as a date.

Thanks

Wed-30-11-22

 

[Fluff]

If it's a real date & not text, try

=EOMONTH(A2,-1)+1

 

[thedeadzeds]

If it's a real date & not text, try

=EOMONTH(A2,-1)+1

Thanks, it looks like it text not a date

 

[Fluff]

Ok, how about

=EOMONTH(RIGHT(A2,8),-1)+1

 

[thedeadzeds]

Ok, how about

=EOMONTH(RIGHT(A2,8),-1)+1

Perfect thank you

 

[Fluff]

You're welcome & thanks for the feedback.