# Need Numbers Inputted and Deleted

#### rebel123

##### Board Regular
Thanks for your help.
Not sure if there is even an = equation for this. Please see attachment.
If there is a solution, please respond with =

So, most likely, the correct answer will start with =D5 or will at least include = and D5 somewhere
in the equation. I need a drag-down formula.

Thanks!

#### Attachments

• Screen Shot 2021-03-02 at 1.38.19 PM.jpg
116.2 KB · Views: 13

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

#### Joe4

##### MrExcel MVP, Junior Admin
What exactly is your question?

#### rebel123

##### Board Regular
The correct answers are in Yellow BUT how do i make a formula for that?

#### Joe4

##### MrExcel MVP, Junior Admin
It would be helpful if you clearly define the rules for the conversion.
Otherwise, we would be forced to make assumptions based on the sample data, that may not always hold true.

#### rebel123

##### Board Regular

ADVERTISEMENT

Yes but it says... will start with =D5 so therefore it's easy to assume where the answers lie... Thanks!

#### Joe4

##### MrExcel MVP, Junior Admin
Yes but it says... will start with =D5 so therefore it's easy to assume where the answers lie... Thanks!
Hmmm... I still don't think it is clear what you are after.
Based on your comment in reply number 3, I was assuming that you want to take the values in column C, and convert them to what is shown in column D.
Is that not the case?

If that is what you are trying to do, I don't want to make any assumptions. Especially since the rules for the last entry appear to be very different than the first three.

Make it easy for us to help you by being thorough and clear what you are after!

#### rebel123

##### Board Regular

ADVERTISEMENT

Gotcha. Sounds like drama. I have not heard any answers. Thanks!

#### rebel123

##### Board Regular
Yes, but the admin already said there are at least 2 different answers out of the 3...

#### Fluff

##### MrExcel MVP, Moderator
@jtakw
The 2nd of those has already been closed by me & the 1st one is (IMO) sufficiently different to this question.

Replies
1
Views
49
Replies
1
Views
62
Replies
12
Views
176
Replies
3
Views
75
Replies
12
Views
218

Threads
1,127,009
Messages
5,622,149
Members
415,881
Latest member
tasic89

### 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

### 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