EXCEL - Need help combining SUM formula and CONCATENATE in one cell

[candis2k6]

Step 1: FIELD B1 equals a date + 14
Step 2: FIELD B1 needs to be formatted to add back preceding zeros

I have successfully created each step but cannot combine them in one field.

B1=A1+14 and =CONCATENATE(TEXT(MONTH(B1),"00")&"/",TEXT(DAY(B1)&"/","00"),YEAR(B1))

I need to figure out how to combine these two formulas, the second formula uses the RESULT from the first.

EXCEL 2010

 

[Scott Huish]

Why do you need Concatenate? If B1 contains a date:

=TEXT(B1,"mm/dd/yyyy")

or

=TEXT(A1+14,"mm/dd/yyyy")
if you are trying to get rid of the formula in B1.

or you could just do:
=A1+14
and format the cells as mm/dd/yyyy

 

[candis2k6]

Thanks, you're right. That is much easier!