You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

show short form of date

Hi,


Actually I treid to enter the german support forum, but apple won´t let don´t know why. So here we go:


I´m creating a calendar spreadsheet.

Column A uses A1 =DATUM(JAHR(A1);MONAT(A1);TAG(A1)) to show a specific date (that´s DAY(Year... (Month (Day..)))

A4 looks like: =A1

A5 will look like this: =DATUM(JAHR(A4);MONAT(A4);TAG(A4)+1) (So I´m incrementing the days)

A6 will be =DATUM(JAHR(A5);MONAT(A5);TAG(A5)+1)

I´m using this to create the days for a specific month. Works fine.



So now after I have all the dates created in Column A, I want the days of the week to display in column B.


So I use: =TAGNAME(A4) (which translates into DAYNAME(A4)). Works great I get all the right days of the week. BUT: Numbers gives me the full Name of the Day not the short one.


So I get for example "Monday" but I want "Mo" instead.


So I open the info Dialog for the cell. I create my own format and it let´s me choos wether I want the full Name or short Version. I choose the short Version but it does not display. I still get the long name of the day. Ideas anybody?


Thanxs


User uploaded file

MacBook Pro, Mac OS X (10.7.2)

Posted on Apr 5, 2013 11:18 AM

Reply
Question marked as Top-ranking reply

Posted on Apr 6, 2013 12:02 AM

HI Peter,


In Column A:


A4: =A1

A5: =A4_1

Fill down.


In the (US/North America) English localization, Numbers offers a Date and Time format that includes the (short) day. Unfortunately, it also includes the year. If acceptable, you might eliminate column B and use that format for the dates in column A.

User uploaded file


TAGNAME(D&U) returns a text string. The Datum & Uhrzeit format requires a Date & Time value, and ignores text.


If you do need to put the (short form) Tag der Woche in column B, replace your formula with =A then apply the custom format.


Regards.

Barry

2 replies
Question marked as Top-ranking reply

Apr 6, 2013 12:02 AM in response to Struwwwelpeter

HI Peter,


In Column A:


A4: =A1

A5: =A4_1

Fill down.


In the (US/North America) English localization, Numbers offers a Date and Time format that includes the (short) day. Unfortunately, it also includes the year. If acceptable, you might eliminate column B and use that format for the dates in column A.

User uploaded file


TAGNAME(D&U) returns a text string. The Datum & Uhrzeit format requires a Date & Time value, and ignores text.


If you do need to put the (short form) Tag der Woche in column B, replace your formula with =A then apply the custom format.


Regards.

Barry

show short form of date

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.