I need your help.

The following formula is in cell A4, copied down to cell A8:

=IF(D4<>"",MID(YEAR(D4),4,1)&TEXT(MONTH(D4),"00")&MID(C4,1,1)&"-"&MID(B4,1,1)&MID(B4,FIND(" ",B4)+1,1)&TEXT(COUNTA($D$4:D4),"000"),"")

The following names are in range B4:B8:

Jane Doe

Sister Rock

David ****

Sussie Jay

Tom Jones

The following two-digit codes are in range C4:C8:

AB

XY

JT

PQ

EF

Cell D5 contains the date:

04-Aug-07

Cell D7 contains the date:

21-Aug-07

As a result, cell A5 shows

**708X-SR001**and cell A7 shows

**708P-SJ002**.

If I enter 23-Aug-07 in cell D4, cell A4 would show

**708A-JD001**, and cells A5 and A7 would change to

**708X-SR002**and

**708P-SJ003**, respectively, but I need cell A4 to show

**708A-JD003**and cells A5 and A7 to retain their original values.

Any help, please.

Thank you,

Gos-C