Is there an IF formula that stipulates if cell A contains the word "DOC" then Cell C will populate the date in MMDDYEAR format? Also if there are additional instances of the date being used it would need to add 01, 02, etc. after the date. Thanks!
<tbody>
</tbody>
Type | Date | ID |
DOC | 4/11/18 | 04112018 |
DOC | 4/11/18 | 04112018 01 |
DOC | 4/11/18 | 04112018 02 |
<tbody>
</tbody>