In my code, I am letting the user insert a desired date. I then use today's date and the user's input date to calculate the number of days that have passed since the input date & update it daily. This is the code.
Target.NumberFormat = "0"
Target.Formula = "=Today()- " & CLng(Target)
However, I am trying to add "Day/s Ago" after the formula output but it doesn't work (Ex: 4 Day/s Ago).
Tried to use & "Day/s Ago" after the formula but it didn't work.
Any clue how can I get it working?
Target.NumberFormat = "0"
Target.Formula = "=Today()- " & CLng(Target)
However, I am trying to add "Day/s Ago" after the formula output but it doesn't work (Ex: 4 Day/s Ago).
Tried to use & "Day/s Ago" after the formula but it didn't work.
Any clue how can I get it working?