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

**URL:** <https://boards.straightdope.com/t/dates-and-what-day-of-the-week-they-fell-on/712353>\
**Category:** Factual Questions\
**Created:** [February 11, 2015, 1:14am UTC](https://boards.straightdope.com/t/dates-and-what-day-of-the-week-they-fell-on/712353 "2015-02-11T01:14:11Z")\
**Posts on this page:** 2\
**Page:** 2

<div class="post-metadata">

**Author:** ![OldGuy](https://avatars.discourse-cdn.com/v4/letter/o/3bc359/32.png) [@OldGuy](https://boards.straightdope.com/u/OldGuy)\
**Post date:** [February 12, 2015, 2:54am UTC](https://boards.straightdope.com/t/dates-and-what-day-of-the-week-they-fell-on/712353/21 "2015-02-12T02:54:00Z")

</div>

> [@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.

---

<div class="post-metadata">

**Author:** ![74westy](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/74westy/32/3950_2.png) [@74westy](https://boards.straightdope.com/u/74westy)\
**Post date:** [February 12, 2015, 4:17pm UTC](https://boards.straightdope.com/t/dates-and-what-day-of-the-week-they-fell-on/712353/22 "2015-02-12T16:17:00Z")

</div>

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

[Previous page](https://boards.straightdope.com/t/dates-and-what-day-of-the-week-they-fell-on/712353.md?page=1)