Trying to Auto Calculate Dates with Words in cell

[paulepage14]

Hi, I am not sure if will explain this right, I am trying to get certain cells to auto calculate the dates with Words in the cell. EX: "Completed on Days" Monday October 1st is there a way to make the next day calculate with "Completed on Days" Tuesday October 2nd? I have attached an excel file to show what i would like it to do. Much appreciated. Thanks

[Glenn Kennedy]

This might be easier if the year was also present...

[paulepage14]

I am ok with the year being present, as long as i would be able to autofill the cells. Thanks

[Glenn Kennedy]

OK. In A1:
=TEXT(DATE(2017,10,1+INT((COLUMNS($A1:A1)-1)/2)),"dddd")&" days completed"&CHAR(10)&
TEXT(DATE(2017,10,1+INT((COLUMNS($A1:A1)-1)/2)),"dd/mm/yyyy")

In B1:
=TEXT(DATE(2017,10,1+INT((COLUMNS($A1:B1)-1)/2)),"dddd")&" afternoonmss completed"&CHAR(10)&
TEXT(DATE(2017,10,1+INT((COLUMNS($A1:B1)-1)/2)),"dd/mm/yyyy")

Select BOTH cells and drag across.

How does this look??

[Glenn Kennedy]

I've just realised you're in Canada and probably use the daft USA mm/dd/yy system, unlike everyone else in the world... I can modify this, of course, but first see if it's broadly what you want...

[paulepage14]

This is perfect, I really appreciate this. Much appreciated. Thanks

[Glenn Kennedy]

So, you're OK to do any modifications yourself?

thanks for the Rep, BtW...

[paulepage14]

Yes, That was perfect, I changed the date format a little but the rest was awesome. Again thanks for your time.

[Glenn Kennedy]

OK. Anytime...