Formula showing a TEXT & date, in the next column i need to add 2 days on the date

[JessSilvertail]

I am entering Estimated completion dates into Excel.

Stage 1 completed on 1/4/16 so in the next column under stage 2 I want it to calculate 2 days from the 1/4/16 (Estimating Stage 2 will complete 2days after stage 1) but I want the words ETA at the front of the date. example. in Stage 2 column it will say - ETA 3/4/16.

Then under stage 3 i want it to add on 4 days from 3/4/16. I.e under Stage 3 it will say - ETA 7/4/16

The formula i have so far is ;
In Stage 1 column i have the date as 1/4/16
In Stage 2 Column i have the formula ="ETA"&" "&TEXT(A1,"DD/MM/YYYY") so the cell shows as ETA 01/04/2016
But what i need it to show is "ETA 3/4/16" adding on 2 days from stage 1
then in Stage 3 i need it to show as ETA "7/4/16" adding on 4 days from stage 2

I know to add days you simply =A1+2 but how do i add this formula onto the end of my formula ="ETA"&" "&TEXT(A1,"DD/MM/YYYY") ?

I hope this makes sense

Thankyou
Jessica

[Pete_UK]

You can do this:

="ETA"&" "&TEXT(A1+2,"DD/MM/YYYY")

to add two days on to the date in A1.

Hope this helps.

Pete