Where else have Microsoft crapped on EXCEL 2013

[Brianwarnock]

I have a spreadsheet logging my walking activity, but the =DAY() function is wrong for 2014 such that 31/12/2013 correctly returns Tuesday but 1/1/2014 returns Sunday |||

I wonder if 2+ 2 still equals 4

Brian

 

[Brianwarnock]

The plot thickens as it works ok in a sheet imported from 2002

brian

 

[Galaxiom]

Are you sure it is Microsoft with the problem?

Day() returns the Day (1 to 31) of the date in the argument.
It will return 1 from 1/1/14

If you apply WeekDayName to that result you will get Sunday.

 

[Galaxiom]

What is probably happening is 1/1/2014 is being treated arithmetically.

The result of that division is not much above zero. Hence (assuming you used a technique that actually returns the day name), you will get the week day for Excel's zero day, 0/1/1900 which was a Sunday.

 

[Brianwarnock]

Oops, most fulsome grovelling apologies, I thought that I had deleted this thread yesterday before anybody had replied to it. As Galaxiom pointed out it was me not Microsoft that was at fault, in the xls sheet I had merely said =A2 and formatted the cell dddd A2 contained the date, I had a brainstorm when creating my new sheet and put = Day(A2) , I had realised within a few minutes and deleted the thread, so I thought.

One very embarrassed Brian

 

[Rx_]

We all go down that path, me probably more than others.
Thanks for letting us know. That is the important part.

I am getting ready to test Access 2013 with a lot of Excel 2013 remote automation that uses vba to create formulas, formatting and more. Keeping an eye on all these articles.