Dates and times

Hi Alex

Thanks for getting in touch. Yes, this is possible and I'll give you two options:

1. You can duplicate the date into another cell, then right-click the cell and choose Format Cells. Choose custom and then in the box type "dddd". This will give you the day of the week in long format. If you use "ddd" you will get a three-letter format (e.g. Mon instead of Monday).

2. Use the TEXT function to convert it. If your date is in A1 you can try

=TEXT(A1, "dddd")

for similar formatting as above.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector