Thread: Formatting date as first letter of day only
View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
  
Posts: 99
Default Formatting date as first letter of day only
Hi Gavin,

I created an other option:


=CHOOSE(WEEKDAY(B2;1);"S";"M";"T";"W";"T";"F";"S")

where B2 holds the date.

So something without VBA


HTH,

Wouter
Reply With QuoteReply With Quote