Can Excel COPY DATE Values from one cell to another in MMDDYEAR format

[NEW_2VBA]

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!

Type	Date	ID
DOC	4/11/18	04112018
DOC	4/11/18	04112018 01
DOC	4/11/18	04112018 02

<tbody>
</tbody>

 

[Joe4]

And what should it populate if column A does not equal "DOC"?

Assuming that your data starts on row 2, here is a formula what will do what you want, and return nothing (blank) if column A is not equal to "DOC".
Place this in cell C2 and copy down for all rows:

=IF(A2="DOC",TEXT(B2,"mmddyyyy ") & TEXT(COUNTIFS(A$2:A2,A2,B$2:B2,B2),"00"),"")

 

[NEW_2VBA]

Thanks! It worked

 

[Joe4]

You are welcome.

 

[NEW_2VBA]

Hello! I attempted to add additional conditions to this but it works partially; it adds the value MMDDYEAR but doesn't count the new specified values included in the OR portion of the formula. Can anyone help me pinpoint my error?

=IF(AND(M2=1,OR(A2="DOC",A2="RCPT",A2="INV")),TEXT(B2,"mmddyyyy ") & TEXT(COUNTIFS(A$2:A2,A2,B$2:B2,B2),"00"),"")

 

[Joe4]

I am a very visual person.
Can you post some examples, like in your initial post, along with expected results, so we can better understand exactly what you are looking for.

 

[NEW_2VBA]

	A	B	C	M
1	Type	Date	ID	Rate
2	DOC	4/11/2018	04112018	1
3	DOC	4/11/2018	04112018 01	1
4	RCPT	4/11/2018	04112018 03	1
5	INV	4/11/2018	04112018 04	1

<tbody>
</tbody>

Hope this helps, thanks!

 

[Joe4]

OK, so you do not want each Type to have its own separate sequence (they should all be treated the same).
Try this:

=IF(AND(M2=1,OR(A2="DOC",A2="RCPT",A2="INV")),TEXT(B2,"mmddyyyy ") & TEXT(COUNTIF(B$2:B2,B2),"00"),"")

 

[NEW_2VBA]

Thanks. That formula seemed to count every line item with the same date and include it in the sequence without looking at columns A & M.

 

[Joe4]

Isn't that what your example up in post 7 shows?
If not, then please explain the logic regarding how to arrive that you want column C to show.