Hi guys! Can you please help to write simple code in VBA so it will contain the following (in Excel in one line combine text and current date). Example: in Excel i expect to see the following =IF(A28="","","Processed(current date)")
I have this below written in VBA:
sFormula4 = "=IF(A27=" & Chr(34) & "" & Chr(34) & "," & Chr(34) & "" & Chr(34) & "," & Chr(34) & "Processed" & Chr(34) & ")"

My question: how to write code so it will add current date after word Processed? Format mmddyyyy, so it will look like Processed06182020.

Thanks