Text function returns wrong day when converting

Skeptical · Newbie Joined: 30 Jan 2011 Posts: 1

Just to make this simple assume the following:

A1 contains the day January 23, 2011 formatted as 2011-01-23 (which is a Sunday)

A2 contains the formula =day(a1) and correctly displays 23 (not going to be used, just put this in for testing)

A3 contains the formula =text(day(a1); "dddd") and incorrectly displays Monday

Huh?

Edit: Disregard, changed to =text(a1; "dddd") and it worked. Now if only working with dates wasn't so complicated and the help so unhelpful maybe this problem wouldn't crop up.

Villeroy · Posted: Sun Jan 30, 2011 2:25 pm Post subject:

Working with dates and times is extremely easy once you understand that they are nothing but numbers on a time scale.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org