Short date in A show as weekday in B

rich

New member
Joined
Nov 5, 2018
Messages
7
Reaction score
0
Points
0
Excel Version(s)
Prof. Plus 2016
Can anyone help me achieve this result:
ONLY when a short date (11/5/18) is entered into a cell in column A will the corresponding cell in Column B display a 3 letter abbreviated day (Mon). If no date is in a cell in column A then nothing is displayed in column B cell(s). Thank you for your help!
 
.
Here is one method :

A
B
1
11/5/18​
Mon​
2
3
4
5
Format Col A for DATE 3/14/01​
Format Col B CUSTOM / ddd​
 
Thank you, Logit! Please forgive my ignorance, but I don't know how to make Col B auto populate once the date is input into Col A. I've tried several formulas but they always populate Col B to "SAT" even though Col A has no data. This is what I want to avoid.
 
.
My apologies .. my mind drifted off somewhere while answering.

In B1 enter this formula :
Code:
=IF(A1="","",A1)

Then if you click on B1, you will notice a small dot in the lower right hand corner. Left click and hold and drag down Column B as far as needed.

Alternatively, if there are additional rows of dates in Col A (say from A1 down to A25), you can double click that dot in B1. The formula will
autopaste down Col B as far as there is data in Col A.
 
That worked beautifully!! Thank you so much for your help!!
 
You are welcome.
 
Back
Top