Get the weekday

[Remsnow]

Hi

We have job requests that come in a specific format. Most of it is fine, but we would like to change the start and end dates to include the days of the week.


The current format is;



Ref: HH65161651
Job role 12345 | xxxxxx
xxxxx site xxxxxxx
Rota: 21:00-09:30 238073
From - 18/01/2019
To - 21/01/2019




We would like the format to be;


Ref: HH65161651
Job role 12345 | xxxxxx
xxxxx site xxxxxxx
Rota: 21:00-09:30 238073
From Friday - 18/01/2019
To Monday 21/01/2019

Ideally we could drop the 6 lines of text into an excel spreadsheet and it automatically updates to include the day of the week. I know this may seem like a small issue, but we deal with hundreds of shifts a day!


Any help would be appreciated.


Many thanks
Graham

 

[mole999]

not sure how you might automate that, you could get the day to the right using

=TEXT(RIGHT(A1,10),"dddd")

 

[Remsnow]

Hi, this is just putting the date format in as 8/01/2019. I changed the 10 to 11 and it gave me 18/01/2019, but it is not giving me the weekday. Sorry!

 

[mole999]

Does this force it

=TEXT(--RIGHT(TRIM(A1),10),"dddd")