Hi
I have never used VBA before and need help with the following.
I need to convert a date to the shortened abbreviation of the day of the week that the date relates to. i.e. 26/06/2017 = Mon.
in excel I can achieve this by using =text(A1,"ddd"), when i have incorporated this into a VBA...