Can I create my own date showing day of week plus date?

T

tjsmags

I would like to enter the date, such as 10/04/09, and have it show up in the
cell as:
Sun 10/04/09

Is this possible? Right now all I see for formatting the date showing the
day of the week shows: Sunday, October 4, 2009 (it's spelling out too much
for me...I want everything abbreviated).

I would like only the first 3 characters for the day of the week and then
the date using numbers as xx/xx/xx.
 
J

Jacob Skaria

Right click the cell/range>Format Cells>Select Category as 'Custom'. Within
the text box labeled 'Type:' enter the below

ddd mm/dd/yyyy

If this post helps click Yes
 
T

T. Valko

Use the custom format of ddd m/dd/yy.

Enter the date as usual: 10/4/2009 and it will display as Sun 10/04/09.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

day of the week and date formula 2
Max-Min with specific criteria 1
Week Number Format 4
Calculating tasks using a six day work week 1
Calculating a week between a range of dates 3
Day of Week and Date 15
Convert Week Number to Date 1
Check if a date comes before/after a range of dates 0

Top