Dates, and what day of the week they fell on.

[OldGuy]

@Senegoid

IIRC, Visual Basic lets you write a date enclosed in #…# punctuation marks, to make it unambiguously a date, e.g., #1954/12/31#

Given that MS Offics apps (including Excel) are all Visual Basic behind the scenes, can you use that syntax in the formulas you put in cells? Can you write =WeekDay(#1954/12/31#) ?

The answer to his is apparently no – at least in my version of Excel.

=WeekDay(#1954/12/31#)

only gives an error message.

[74westy]

=WEEKDAY(“1954/12/31”) works for me in office 2010