I'm so close... Concatenating a date and adding 30 days

[MrBurn5]

(Why is my forum tools add on making the data look like this? Am I using an old version?)

This is even mission critical, I just want to do it on my invoices because it can be done.

I currently just manually add 30 days to the invoice date, then use the last four digits of the customers phone number to generate the invoice numbers.

The phone number is in A13, invoice date is in B15, the result I want is in C15, the closest I can get is the test in cell E14.

(sorry again for the way this looks, if someone can direct me to a better add on I'd appreciate it.)


[TABLE="class: head"]
<tbody>[TR]
[TH] [/TH]
[TH]

A​

[/TH]
[TH]

B​

[/TH]
[TH]

C​

[/TH]
[TH]

D​

[/TH]
[TH]

E​

[/TH]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]513.671.1111[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD]

Order Date​

[/TD]
[TD]

Invoice Date​

[/TD]
[TD]

Invoice Number​

[/TD]
[TD][/TD]
[TD]=SUBSTITUTE(CONCATENATE(B15,RIGHT(A13,4)),"/","")[/TD]
[/TR]
[TR]
[TD]

15​

[/TD]
[TD]

07/02/18​

[/TD]
[TD]

07/13/18​

[/TD]
[TD]

0812181111​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet1[/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

Try

=TEXT(B15+30,"mmddyy")&RIGHT(A13,4)

 

[Fluff]

Why is my forum tools add on making the data look like this? Am I using an old version?

Looks like it.
You can find newer versions if you follow the link in my signature.

Are your dates real dates or text that look like dates?

 

[WassimN]

the closest I can get is the test in cell E14.

What does this mean?

Try this: =CONCAT(RIGHT(A13,4),"--",TEXT(B15+30,"MM/DD/YYYY"))

This uses a phone format like: ###-###-#### and a date format as it shows MM/DD/YYYY if you need to change these then just make sure that the RIGHT() function gets you want you want.

Also, The TEXT() function takes the value in B15 addes30 and then format the answer as a date in the format given.

Hope this helps.

 

[MrBurn5]

What does this mean?

Try this: =CONCAT(RIGHT(A13,4),"--",TEXT(B15+30,"MM/DD/YYYY"))

That was my version of forum tools not working correctly. Here's what apparently got cut off from cell E14: =CONCATENATE(SUBSTITUTE(B15,"/",""),RIGHT(A13,4))

 

[MrBurn5]

Looks like it.
You can find newer versions if you follow the link in my signature.

Got it! Thank you!

 

[Fluff]

Judging by your formula, it looks like the dates are text, in which case try
=TEXT(DATEVALUE(B15)+30,"mmddyy")&RIGHT(A13,4)

 

[MrBurn5]

Try

=TEXT(B15+30,"mmddyy")&RIGHT(A13,4)

Bingo, that's it. I must have overthought the problem.