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
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
Last edited: