Delete the word "day" in the cell (cell design)

[YosiSMS]

hello,
i need to design a workers shifts table and the manager asked me to delete the word "day" from the date.
so i insert the date (lets say 13/07/2019) and in the "cell design" option i put "dd-mm ddd" so in the cell i see "13-07 day 6"
how do i delete the word "day" becuase when i put "dd" it says the day in the month (13) and when i put "ddd" it says the day in the week with the word day (day 6), i want it to say only (6).
if it metters im using excel in the hebrew languge, so its says (13/07 יום ו).
thank you for the help

[AliGW]

This format returns this for me:

13-07 Sat

dd-mm dd should give you 13-07 13

[YosiSMS]

I think it happans to me beacuse im using hebrew. Is there an option to control the "cell desing" option so it will delete the word "day" or i have nothing to do about it?

[AliGW]

You can replicate what you want directly in the cell itself.

Change the cell formatting back to general and then use this in the cell itself:

=TEXT(TODAY(),"dd-mm")&" "&WEEKDAY(TODAY(),2)

[YosiSMS]

WOW! thanks it helped me! i just have one problem. insted of the number "6" i need it to be the hebrew 6th letter.
if ill translate it to english it will be: dd-mm day A, dd-mm day B, dd-mm day C, dd-mm day D, dd-mm day E, dd-mm day F, dd-mm day G.
this is how we do it in israel.
is there an option for that? without the "day"..

[AliGW]

Sorry - I can't help any further as I don't have the Hebrew version.

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

[AliGW]

You could try this:

=TEXT(TODAY(),"dd-mm")&" "&CHOOSE(WEEKDAY(TODAY(),2),"A","B","C","D","E","F","G")

[YosiSMS]

YES!!!!!!!!! THANK YOU!!!!!!!
one lest question, if i want it to be another date. lets say 1/8/2019. where do I change that? and if i do change it, if i drag the cell down do the date change (one cell down will be 2/8/2019 and so on)?

[AliGW]

Try this:

=TEXT(DATE(2019,8,1)+ROWS(A$1:A1)-1,"dd-mm")&" "&CHOOSE(WEEKDAY(DATE(2019,8,1)+ROWS(A$1:A1)-1,2),"A","B","C","D","E","F","G")

You have to set the date in both places in the formula, but then dragging it down increments the date.

[YosiSMS]

thats it! its perfect. thank you very much!!!

[AliGW]

No worries.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[AliGW]

By the way, if you want to type the start date into a cell (e.g. 01/08/2019 in C1), you can reference that instead of messing with the formula:

=TEXT(DATE(YEAR(C$1),MONTH(C$1),DAY(C$1))+ROWS(A$1:A1)-1,"dd-mm")&" "&CHOOSE(WEEKDAY(DATE(YEAR(C$1),MONTH(C$1),DAY(C$1))+ROWS(A$1:A1)-1,2),"A","B","C","D","E","F","G")