Ive got a list of dates in column B in an excel spreadsheet, id like to populate column A with the day (mon - sun) that relates to that date eg. if we where going the day of this post it would be :
Column A: Wednesday, Column B: 14/09/16
Ive started writing a formula to work out the day number of the year eg. 1st jan would be 1 and then by manually knowing the first day of the year for one year work out the others, then +/- a day for each year past and forward, but this seems overly complex is their a simpler way to do it ?