In a monthly spreadsheet I have cells which contain the year (
A1) Month (
A2) and then the rest of the column running from cell
A4 through to
A34 numbered as the day in the Month (1 to 31).
My objective is to place the correct day of the week (in text) besides the day of the month (number).
So far I have successfully used the following formulae individually -
=(DATE(A1;A2;A5)) in this case returning
=CHOOSE(A4;"Mon";"Tue";"Wed";"Thu";"Fri";"Sat";"Sun") returning Mon (
=WEEKDAY(DATE(A1;A2;A5);2) which gives 5 indicating Friday (correct for
WEEKDAY(date()) returns the number of the day and parameter 2 indicates that the week begins on Monday.
The date format required is the English version
What I now need to do is to somehow combine these formulae to copy down in cells B4 to B34 in order to place the correct day of the week against the day number in respect of that month but this so far eludes me.
A suggested working formula would be much appreciated.
The references I have used:
Interestingly, all these references suggest comma delimiters rather than semicolons between the formula elements.