Date format in Excel 365 for Mac

[griffij]

Good evening/Morrning,

I am trying to display a date as in excel but all I want the user to see is the first letter of the day M for Monday, T for Tuesday and so on? The smallelest I can seem to make it is the first three letters 'Mon, Tue ...' and so on can anyone please help?

Thanks Joel

 

[kevin9999]

If you use a helper column to display the date it's relatively simple. Suppose the date is in A1:

=Left(Text(A1,"ddd"))

Or if your dates are derived via a formula, you could probably incorporate something similar into the formula itself.

 

[SunnyAlv]

Try This

=LEFT(TEXT(TODAY(),"DDD"),1)