Formula needed to pull out dates from cell

P

Pizzio

Active Member
Joined
Apr 28, 2005
Messages
268
I need a formula that can pull out the date values from cell data.

EXAMPLE: - typical cell A1 data
10095238 M RT 0222-0222 030ACU

Expected outcome:
B1 02/01/22 - start of month
C1 02/28/22 - end of month

Any thoughts?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
Hi,

With your 1 sample:

Book3.xlsx
ABC
110095238 M RT 0222-0222 030ACU2/1/20222/28/2022
Sheet1029
Cell Formulas
RangeFormula
B1B1=REPLACE(MID(A1,FIND("-",A1)-4,4),3,0,"/1/")+0
C1C1=EOMONTH(REPLACE(MID(A1,FIND("-",A1)+1,4),3,0,"/1/"),0)
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Automate data pull from one file to another
Replies
1
Views
189
John_w
J
G
  • Solved
Counting zero billing days in Excel until current date
Replies
5
Views
558
awoohaw
awoohaw
S
  • Solved
Using a helper cell to return a month value
Replies
5
Views
281
Joe4
Joe4
J
  • Solved
Display date from a range within last 6 months
Replies
5
Views
300
Peter_SSs
Peter_SSs
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
242
Insurance Dave
I

Forum statistics

Threads
1,215,050
Messages
6,122,868
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top