ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I format the date so that I have the name of the day abrevi (https://www.excelbanter.com/excel-discussion-misc-queries/231329-how-do-i-format-date-so-i-have-name-day-abrevi.html)

Elbridge Gerry Puckett

How do I format the date so that I have the name of the day abrevi
 
I know how to obtain

Tuesday, May 19, 2009

for today's date. But how can I change the Tuesday to Tues? Or Friday to
Fri, etc.

Thanks!

- EGP


T. Valko

How do I format the date so that I have the name of the day abrevi
 
Use this custom format:

ddd, mmmm d, yyyy

--
Biff
Microsoft Excel MVP


"Elbridge Gerry Puckett" <Elbridge Gerry
wrote in message ...
I know how to obtain

Tuesday, May 19, 2009

for today's date. But how can I change the Tuesday to Tues? Or Friday to
Fri, etc.

Thanks!

- EGP




FSt1

How do I format the date so that I have the name of the day abrevi
 
hi
this may post twice. my first post attempt crashed. i think.

custom format

ddd, mmm dd, yy 'all abbreviated
or
ddd, mmmm dd, yyyy ' long version

regards
FSt1

"Elbridge Gerry Puckett" wrote:

I know how to obtain

Tuesday, May 19, 2009

for today's date. But how can I change the Tuesday to Tues? Or Friday to
Fri, etc.

Thanks!

- EGP



All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com