Concatenating Data -troo few arguments

[howard]

I have the folowing data in B2

I am battling to get this part to work

 Please give me feedback by "&text(workday(today()+5),"dd/mm/yyyy")&"

See full formyula below

=IF(HOUR(NOW())<12,"Good Morning ",IF(HOUR(NOW())<18,"Good Afternoon ","Good Evening ")) &'Ageing Summary'!M1&CHAR(10)&CHAR(10)&

"Attached please find Cash Sales

Please chase up on those Cash Sales that are over 3 days, which amounts to "&TEXT('Ageing Summary'!B1,"R#,##0.00")&".

Please give me feedback by "&text(workday(today()+5),"dd/mm/yyyy")&"


Regards

Howard"

Kindly amend me formula

 

[Fluff]

Replace the + sign with a comma.

 

[RoryA]

I suspect that workday(today()+5) should be workday(today(),5)

 

[howard]

Thanks for your input, I replaced the + with a comma and kit worked

 

[Fluff]

Glad we could help & thanks for the feedback.