Thread: How to display month in a column based on a value in a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How to display month in a column based on a value in a cell
D1 has a date for which I want the first 3 characters of the month to be
displayed in column A1

Assuming D1 down contains real dates
In A1, copied down: =IF(D1="","",TEXT(D1,"ddd"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
Reply With QuoteReply With Quote